Answer Questions

• someguywithoutadisplayname Failed to generate a user instance of SQL Server...

  I wanted to upgrade SQL Express upto SQL Express Adv with Reporting services to see how it works. I deinstalled SQL EXPRESS Server and installed new SQL Express Advanced with Reporting Services checked. After this step VS C# Express cannot open old Data connections and cannot create a new one. The error message is: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The co ...Show All

• Dave Corun Deploying Jet OleDb Provider

  If I'm posting to the wrong forum, please correct me. I'd like to use an Access database for an application I'm developing for retail sale, and I need to do these things: Determine during setup if the target machine has the Jet OleDb Provider installed. If so, determine whether the version is adequate. If necessary, install the correct provider. I don't seem to be able to find any documentation or downloads covering this scenar ...Show All

• Cert123 Storage of packages: file system or Sql Server?

  HI, we are beginning a new project at my company and I was wondering where is the best place to save SSIS packages: file system or SqlServer. I have used other ETL products and they always create a repository on an RDBMS. Since SSIS offers us the choice of DB storage or file system, is there pros and cons of both approach Will the deployment of our application be simpler by using Sql Server since we would onky move metadata instead of files ...Show All

• OlliH Running a package in C#

  Hello all. I am trying to run a package in C# and have come accross the help file of how to do it in Visual Basic ('Running an Existing Package using Visual Basic'). However, I cannot find a reference to anything relating to DTS in my reference dialog. In the help file it says to add a reference to Micorsoft.SQLServer.ManagedDTS.DLL, however, I cannot find this reference anywhere. Am I missing something Thanks, Mike GAC stands for Glob ...Show All

• Gwenael Need opinion: Server Specs = No. of Concurrent Users

  Dear Anyone, I'd like to get some opinion regarding the specs of a server and how many concurrent users it can handle. Assuming reports are pretty standard with 20k number of rows and no images. We're currently in the process of testing our network against our server against some simulated users. Our server will be exposed to the web. Can anyone please share their opinions in terms of server specs and comfortable number of concurrent us ...Show All

• Shadokin Using WebService Task

  Hello, I'm trying to use this web service : http://office.microsoft.com/Research/Providers/MoneyCentral.asmx WSDL i get an error : "This version of the Web Services Description Language (WSDL) is not supported" What's wrong This is the default error for all parsing related issues the task cannot handle from a given WSDL. In those cases, I would suggest generating the proxy with wsdl.exe, and including it as a reference in a Script Task ...Show All

• nobodyman Query optimization in query that uses CTE.

    Hi Guys, I want to optimize one query which uses the CTE (server 2005 feature). I am sending you the abstract query. currently this query take 4-5 seconds to execute. but i want to reduce it to 1 sec. Plz, do help me, if someone know how to do it. ----------------------------------------------------- DECLARE @X INT DECLARE @LowerGradeRange INT DECLARE @UpperGradeRange INT DECLARE @Keyword NVARCHAR(500) SET @X = 11500001 SET ...Show All

• Jitendra Kumar Mehta SQL Server 2005 Express Installation Problem: Incompatible components from beta version of .NET Framework

  Hi all, Yesterday, I just downloaded the SQL Server 2005 Express (SQLEXPR.EXE) and tried to install it in my Windows XP Pro PC that is on Microsoft NT 4 LAN System. I got the following error:                                          &n ...Show All

• Naethe Manning Instalation SQL 2005

  Dear All, i tried to install SQL 2005 Corp Edition on XP Proff. but it can'nt install properly,there is something missing requirements. and there is a message "http://go.microsoft.com/fwlink/ linkid=50380", i tried to click the following links, but i dont know which one has to be downloaded. Any Idea..... By "Corp Edition" I assume you mean "Enterprise Edition". According to the OS Requirements Table ...Show All

• MFH Schoonbrood unzip file using C# code and asp.net

  hello my problem is how to unzip the file using the c# and asp.net code If you are using .NET 2.0, there is a special class for this. If you are using 1.1, search on the internet for a opensource project named ziplib. (or buy a third party prdouct where you have full support, etc.) HTH, Jens Suessmeyer. Hi, Look in the System.IO.Compression Namespace. HTH., Jens Suessmeyer. ...Show All

• Eric Springer How to load data into a table using a synonym?

  I'd like to use a data flow task to load data into a table by specifying the synonym name of the destination table, instead of the actual table name. The OLE DB Destination is forcing me to pick an actual table or view from a drop down list. Any ideas on how to get around this Thank you. Larry, No, I was talking about source adapters only. -Jamie This will be fixed in SP1, so that synony ...Show All

• Prime Digits using DTS within SSRS

  Hi Guys I have an ancient app that produces a pipe delimited file for the printing of certain invoices (which i can present in reporting services). I am able to fire a batch file or script from this able and pass the name of the file through to the script... My question is: is it possible to have the stored procedure fire a DTS pkg to "massage the data" before running the report Has anyone had any experience doing this or othe ...Show All

• Nel K Analysis Services Taking Forever and Over 800MB Memory....

  Hi, I recently started to use Analysis Services 2005 after i build my cube i initiated the adhoc analysis in Excel... what was my surprise when i saw the msmdsrv.exe process reaching over 800mb Memory occupation... and no data was return for hours... Is this normal When i design the aggregations in that cube i calculted the total items of about 338.323 or so... but then said 0 Agreggations made.. so i get a little bit confused here too... ...Show All

• Odin_dark Installing Certificate on SQL Server 2005

  Hi - I'm trying to implement encryption using a 3rd party certificate. I'm following Uncle Bill's documentation on how to install a cert on the server using MMC... I can import the cert into the certificate store just fine. However, when I go to the SQL Server Configuration Manager and bring up the properties window for "Protocols for <Servername>" there are no certs in the dropdown list on the "Certificate" tab. ...Show All

• cjtaylor Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.

  Hello, Please bear with me as I am no Sql Server guru, but am getting this error that is preventing me from continuing with my development work.  I am the only developer on my team running Sql Server 2005 and it has been working just fine for the last week.  I opened the Management Studio this morning, just like every other morning and got this error: TITLE: Connect to Server ------------------------------ Cannot connect to (local). ...Show All