Answer Questions

• Viral Shah xp_cmdshell: a call to 'CreateProcess' failed with error code: '5' (under SQL2005 RTM)

  I get this error when trying to run xp_cmdshell. I have turned on xp_cmdshell via sp_configure and verified it is on (set to 1) by running sp_configure again. The login trying to run xp_cmdshell has sysadmin privileges. If anyone has a solution please let me know. I've got this working now. Windows support had applied security control to C:\WINDOWS\system32\cmd.exe, once I granted the service account Read &a ...Show All

• LiviuShiva text box sending large amounts of text to next page Microsoft please help

  I have a report that has a text box called Fields!ResolutionText. If the resolution is small the whole report stays on one page. If the Resolution is a long one, the whole text box goes to the next page, leaving the first page w/ only 1/3 with information on it and a huge blank space. How can I force the information on to the first page and to fill the first page before putting the rest of the text on to the second page. Any help would be apprec ...Show All

• Martin Szugat Retrieve Values from SQL Server into Winforms

  Hi all, I want to insert information like SQL Server Version, current sql server user etc into a form, How will I achieve this   I have followed this question at http://www.vbforums.com/showthread.php t=357605  ,but I havent had an answer to my question yet.  Please help, I am stuck and can't go on with my application until I have figured this out. Thanks alot in advance Rudi Groenewald You can ...Show All

• jmparks SqlCeRemoteDataAccess Pull issue with ConnectionString

  I'm getting an error when attempting to pull some data from my SQL Server 2005 database. It throwing an exception on my strSQLConn string with the following message (please replace <MyServer> with my actual server name: Failure to open SQL Server with given connect string. [ connect string = Data Source=<MyServer>;Initial Catalog=MobileParts;Integrated Security=True ] string localstrSQLConn = @"Data ...Show All

• Patrick Hampton Import an mdb file

  Hi everyone, I have an mdb file that I want to import using sql server 2005 express edition. I am using the Management Studio Express and have had no success. Thanks in advance I would post this comment in a new thread... it would be seen easier there... just click new thread at the bottom of the page. Management Studio Express does not include Import/Export functionality, but Access does. See my answer ...Show All

• MrWebber Start and Stop a server using SMO

  I am trying to stop and start a server using SMO in .net 2005.  I cannot find any function calls to do this on the server object like the old DMO has.  The MSDN help system is missing the example to show how this is done. If anyone knows how to do this I would really appreciate some help or sample code.  Thanks       The SQL WMI Provider (which implements the enumer ...Show All

• Chuck Farah Question about Analysis services configuration file

  Hi, all here, Please help: I am currently embedding my own plug-in data mining algorithms added to SQL Server 2005 data miming algorithms family. I can see my own plug-in algorithm apprearing in the analysis services configuration file. After the change of the configuaration file, I have actually restart the analysis services server. But why I can not see my plug-in algorithms available in the algorithms list when I open business intelligence ...Show All

• RobinsonT Run querys after silent installtion SQL 2005 Express

  Hi, I'm looking for a solution to run querys (create databases ed) after a silent installation of SQL 2005 Express edition (example with a .sql file). So users can run a installation unattended with all databases installed and so on. What I got is a document about how to run a silent installation (document " Using Command Prompt Options to install SQL Server Express") but this docs there's no solution how to run querys after the ...Show All

• Binnerup How to store a complex query result somewhere and refresh it hourly/daily/on demand?

  We have some reports run quite slow because the queries are complicate and tables are large. So we create a materialized view in Oracle which store the result from the query and refresh it occationally. How to do this in MSSQL I try the indexed view but seems it has lots of restrictions, our query has sub queries and cross database table joins so can't use the indexed view. Any other object or temp table can be used to cache the report data and ...Show All

• firehorizon HostName and ReinitializeSubscription

  Hello all, I'm having trouble with my Merge Replication setup in regards to changing the HostName property of the SqlCeReplication object. As we all know, if you modify the HostName value, you must then call the ReinitializeSubscription(true) method before calling Synchronize(). Unfortunately, this isn't working for me. Following this sequence of steps consistently results in error messages saying that I need to either call ReinitializeSubs ...Show All

• admoises Automatically Fire Trigger Or Procedure in sql server 2000

  Hi Guys I want to automatically fire a trigger or Procedure every day 8:00 P.m. How can we achieve this is there any way in sql server which checks the time regularly and can fire the trigger or we have to write a batch which runs at the specified time and try to create a situation so that the trigger is automatically fired plssssss get back with solution.. this is very urgent.... thanks in advance... Krishna In Enterprise Ma ...Show All

• Luca_Dellamore - MS Wait for Recieve Fails to recieve message when called from .Net sqlClient

  I have been building out an application and Service Broker has been working great but I have this one nagging problem. There are some scenarios that involve users waiting for a response so I call a stored procedure that sends a message on a service and then waits for a responses on the conversation handle on which it sent the request. When I call the stored procedure from a query window inside management studio it works perfectly. When I call i ...Show All

• derekp DTS Package encounters error while importing data.

  Hello All, I am encountering the following error message while impoting a text file from unix server into SQL Server 2000 table. I contacted MS before and was advised to run a SP which I already did, but I am still getting this error. The intresting thing is that this error always occur at 130,000th row everytime. I wonder it has to do with binary vs ASCII file format on Unix server, when accessing from SQL server within the Window ser ...Show All

• Sachin777 Best way to make a database not in use?

  Hi. I am almost wrapping up a project of my own and I will have the option to restore the database, so dropping the existing one and then running the SQL script to create the database, tables, stored procedures and so on. My question is, (using .NET 2.0 C#) - what is the best way to resolve the "cannot drop database as it is currently in use" message, or some message of the similar sort Even though I specified "USE MA ...Show All

• Jung Yi SQL 2005 Standard error on Windows XP Pro SP2

  When I run the SQLSTD.EXE for the September CTP of SQL 2005 Std I get the following error message: "There is not enough space on drive C:\ to extract this package." I have over 13 GBs on C:\ and I've also uninstalled .NET 2 Beta 2. Anything else I need to do to successfully install this TIA This is a known issue with the compression technology used, please try the workaround specified in: http://support.micros ...Show All