Answer Questions

• Qiuwei Cannot fine the object “MSmerge_ctsv_... Because it does not exists or you do not have permission.

  I keep getting the following error message during the initial merge agent. · “The merge process was unable to deliver the snapshot to the subscriber. If using Web synchronization, the merge process may have been unable to create or write the message file, when troubleshooting, restart the sychronzation with verbose history loggin and specify an output file to write. · Cannot fine the object “MSmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4”, Because it does not exists or you do not have permission. (source: MSSQLServer, Error number 15151) I do see this view in the publication and if I run the following command on the publisher I get… select * from Msmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4 ...Show All

• shafiqm Am I only one with the problem using CSV files?

  Simple thing - trying to set up connection for CSV file. In Microsoft Excel - CSV is displayed OK. However - in SSIS - some records are broken - for example records where Description field contains: ""WHITE HOT."" I'm not expert on CSV format - but aren't double quotes used for escape in csv - and if so then WHY microsoft implements it one of their products and not it SSIS So what am I going to do now Well - it still doesn't work - is there a VB function which can fix CSV files for SSIS import TheViewMaster wrote: Thanks for the link. I was mostly pissed off that my 2 hour project was going to be days worth of work because they decided not to implement CSV. They have done. never ever ...Show All

• Christopher A CREATE ASSEMBLY error: could not be installed

  I ran the following: CREATE ASSEMBLY A3rdPartyDLL FROM 'C:\Program Files\3rdPartyComponents\3rdParty.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS and got the following error message: Assembly 'A3rdPartyDLL' could not be installed because existing policy would keep it from being used. How can I change the 'existing policy' right on. I get the same error regardless of how CREATE ASSEMBLY is called / used. Anybody else out there got a minute to try. just create a VB/C# DLL that refers to Interop.Outlook.dll and make an appointment object. Then see if you can CREATE ASSEMBLY that DLL from SQL SERVER 2005. free case of beer if you can. I aint kidding. I'll send you cash or something ! and I'm talk ...Show All

• KoenP 400: Bad Request

  I am getting an "The request failed with HTTP status 400: Bad Request " Error in Report Manager Webpage. http://servername/Reports The Reportserver itself and reports works fine (http://servername/reportserver). Reports render OK and i am still able to connect to reportserver by management studio. The environment is a W2K3 Standard with SQL 2005 (Build 2153) - and the server is a domain controller. Reporting Service Configuration does not mention any issues - I have reapplied default settings - no change. There are no errors in the eventlog. I need some help - please HANNES This post gave me the finale hint (http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=165851&SiteID=1) - but I do not habe a specific IP address ...Show All

• QCH Linked server 2000 to 2005: Error 17 sql server does not exist or access denined.

  I'm trying to link SQL Server 2000 sp3 to SQL 2005 64 bit. I keep getting Error 17 sql server does not exist or access denined. I tried adding remote user mapping and chaning the linked server properties to "Be made using this security context" without any success. Any help is appreciated. I am also receving this code error, from a .Net 2003/C# to Crystal Report XI. I get: Failled to Connection: [Vendor Error 17]. Is there a security permission that has been overlooked Here is the code I use to access CR XI             ConnectionInfo connectionInfo = new ConnectionInfo();             TableLogOnInfo tableLo ...Show All

• ewitkows Column metadata from Connection Manager programmatically

  Hi all! My problem I've been struggling with is the following. I have a set of text files (around 70), each with different column numbers and types. I define Flat File Connection Managers for each of them where I can nicely rename, set data types and omit certain columns. I do this once and this will be the basis for the rest of the data process (would be nice programmatically too actually). I would like to pump each of these text files into SQL Server tables using CREATE TABLE and BULK INSERT (because do it one-by-one is really a pain). The question is: is there a way to obtain column information (Script Task) from a Connection Manager so I can run CREATE TABLE-s I just need the names, data type for each nothing fancy... (I bumpe ...Show All

• simon_ Database Mirroring

  Hi, Would anyone know if database mirroring with SQL Server 2005 is ready for public use or if it's still being tested. Has anyone been successful at setting it up Thanks, Sylvie It is definitely ready for use. In the versions of SQL Server prior to Service Pack 1, you had to enable a trace flag, but that's all cleared up in SP1. You can find out more about it here, along with the steps to set it up: http://msdn2.microsoft.com/en-us/library/ms177412.aspx If you want to try the client auto-failover, open this page and search for "mirror": http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/SQLServerDatabasesAndSamplesOverview.htm#MirroringFailover ...Show All

• yclearly Persistent communication session inside sqlclr proc?

  I suspect this is very poor design but I've been asked to research this: can I maintain a persistent communication session inside an sqlclr proc (tcp/binary packets) The process has to maintain very high throughput - setting up and tearing down a connection on each transaction is cost prohibitive. For TCO and deployment reasons it is preferable not to have a separate windows service etc that accepts requests from inside the clr proc. Is there the luxury of an alternative integrated into the database if you are satisfied please mark an answer. Thanks, "D" Thanks Derek - I have all the ammunition I need know to make an alternate design proposal. I t ...Show All

• Goran _ Perfecto

  hi, i want to know how to do that: table: costtypes fields : typecode values: amount, vat, duty, table bills: fields:  billid, costtype, amount value bi1      amount    1000 bi1     vat               10 bi2    amount        200 i need to create a view that will display amount, vat, duty as fields. note that these are values in the table. so that i will have billid       amount     vat     duty bi1          ...Show All

• Peejj Is this SQL requirement possible?

  I need a script that enumerates the the databases in a given instance of sql server. Then it needs to output the account with permissions on that server. Finally it then needs to search stored procedured for reference to specific file and account names loaded from a csv file. The results should be output to a text file or displayed in an exportable window format. Thanks a lot can u explain a bit Mani pls: what s the member table used for and how did u join the 2. ( i see the code ) but i need explanantions on what joined columns represent in order to understand. also cn u explain to me just generally the last script, how different it s from the first. just generally. Thanks a lot. How can I change the script ab ...Show All

• Ravi Kanth Koppala Upgrading SQLServer 2000 STD Sp1 to Sp4

  Hello After installing Sql server 2000 STD Sp1 on a server with Windows 2003 server, i have upgrade my Sql server to Sp4. All the setup has been terminated without errors, but if i execute on Q.Analyser : "Select @@version" on the end of line of my query result , i have ....(Service Pack 1) I don’t know , if effectively the upgrade has been terminated with sucess.I try to restart my server several time , but the result of my query is always the same "....(Service Pack 1)" Also, on my firewall server , i ’am create an UDP port 1434, because my ODBC client machine was enable to connect to my server. Could you give me an explanation about, this question, and if i really done the upgrade to my sqlserver. M ...Show All

• Shawn Wildermuth - MVP (C#) Cannot see SQL Server 2005 Services in SQL Server Configuration Manager

  I cannot see any services within "SQL Server 2005 Services" in SQL Server Configuration Manager. I am new to SQL Server 2005 and recently installed all of the SQL Server 2005 64-bit components on to a Windows 2003 64-bit server. I can create and view databases via SQL Server Management Studio. I can also start and stop the SQL Server service for the default instance via SQL Server Management Studio. But I should be able to start/stop the service via SQL Server Configuration Manager and I believe I'm supposed to use SQL Server Configuration Manager to make changes to the services. I'm concerned that something may have become corrupted and is effected the SQL Server Configuration Manager. Any suggestions Thanks in advance, ...Show All

• Thiru_ List of Stored Procedures

  How do I get a list of the stored procedures currently in the database Is there a quick way to edit them Thank you! Hi, if you just want to use a query you can use the INFORMATION_SCHEMA.Views to get the information. If you want to retrieve the data programmtically and as typed objects you should have a look on the SMO classes. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- select * from sys.objects where type = 'P' Thanks Laurentiu ...Show All

• Leo Kent C++ code sample for working with Inegration Service

  Hi All, Are there samples for working with Inegration Service As I see in shipped samples are C# and VB only. Particulary I need a C++ code for "Enumerating Available Packages Programmatically" Thanks a lot. Sergiy Hi Michael, Thanks a lot for answer. It really help. Sergiy The code is very similar to C# code, except that instead of using C# classes you should use COM interfaces, declared in DTS.H (from C:\Program Files\Microsoft SQL Server\90\SDK\Include). Here is some code to get you started (I've skipped any error checking for clarity): #include "dts.h" void EnumPackages() {     CComPtr<I ...Show All

• Erling Ervik About Security between views and tables

  Hi, I've got a table T1 and a view V1 based on T1's rows (but not all rows). I've granted users to do update and select on my View V1. But i don't want users directly update my table T1. then, i log as a standard user in Enterprise mgr, and open my view V1. I modify a value in a field, and when i validate, an error occurs saying i'm not allowed to make Select neither Update on table T1. Is there a way of doing this (sql 2000). Well, I'll be... Have you read through this document to see if you have met the criteria for updateable views http://msdn2.microsoft.com/en-gb/library/ms187956.aspx thanks for the link. yes my view is updateable, and when there's no grant restrictions, it works fine. My p ...Show All