Hi everyone! How can I do to debug a Stored Procedure in SQL Server 2005 from SQL Server Management Studio? I looked for the Debug... option when I right-clicked the SP but it seems that in SQL Sever 2005 doesn't not exist. Thanks. Jaime Lucci ...more >>

Hi, I installed SQL Server 2005 Express on one of my development machine, I had since then having problem connecting to a SQL Server 2000 (On a cluster) database. The problem persist even after I remove SQL Sever 2005 Express. The following is the error message: SAC.EDS.CorpAction.Withholdi...more >>

Running Windows Server 2003 and SQL Server 2000 If we disconnect our 'primary' domain controller we can still log in to our domain as we have another domain controller. Everything seems to work, other than we can no longer log in to SQL Server using Windows Authentifiction. We get a meesage...more >>

I'm running SBS 2003 Premium SP1 and all is well. I've installed a new SQL based application that requires a simple ODBC connection to the SQL database. I have about 50 PCs to setup this ODBC link to my SBS server and there must be a faster way to do this via a script or through Group Polici...more >>

I'm trying to link from sql2005 (64-bit) to sql 7 (32-bit). I get the following error: OLE DB provider "SQLNCLI" for linked server "sql7" returned message "Unspecified error". OLE DB provider "SQLNCLI" for linked server "sql7" returned message "The stored procedure required to complete this...more >>

I'm curious about KB article (903002). http://support.microsoft.com/default.aspx?scid=kb;en-us;903002 In this KB, it says that users that connect with a network packet size greater than 8060, that it requires SQL Server to allocate memory from a region of memory that uses a size of 384 MB. Wha...more >>

Im gette this error when I trie to export data or import data. I have tried to reinstall SSMS This means that it does not work ??? TITLE: SQL Server Import and Export Wizard ------------------------------ Could not set up data flow connections. The connection type "OLEDB" specified fo...more >>

Hi there, I am using SQL Server on my office. I'm rather new to SQL but i was wondering if is possible to connect to this SQL and read / modify a database from my home ? I 'm not intersting to connect to the server over the web. I am using a programm that uses sql server. i want to ins...more >>

Hi I have a VB6 program that talks to SQL Server 2000 database. The Connection String is as below: Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME & ";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source=" & M_SERVER When the program is idle...more >>

have SQL server 05, trying to make a data connection from Visual Studio 03 and get connection failed sql state 08001 sql server error 17 server does not exist, etc. The server does exist, of course- tried both trusted connection and login ID & PW. Am I once again just a MS guinea pig in ...more >>

I want to import varying excel spreadsheets into a sql server 2000 database using the DTS import wizard. The excel spreadsheets are in various formats, differing columns all the time, and the column sizes change all the time. I want to be able to import data from the excel spreadsheet into the...more >>

After a while, I figured out that I cannot connect to my local SQL Server 2k5 unless I specify "localhost\SQLEXPRESS" in the Server Name field. Why can't you just specify "localhost"... what does the "SQLEXPRESS" imply...the service name? The port? Thanks, A...more >>

I have a Windows 2003 svpk 1 server running SQL Ser 2000 svpk 3. Trying to access a asp.net application on the same server and get the following: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied Here is my connection string: sqlConnectionString="data source=12...more >>

I have had some problem with database connection through JDBC (in an earlier post) and have been checking the Server Network Utility. I don't think I made any change. But after that, SQL Server dies and failed to start. here is the error in the log file: -----------------------------...more >>

...more >>

am trying to run a simple .net code thro visual studio in which i just want to display table data into datagrid from sql server running on my local pc. i.e off localhost. but am getting run time error as below. Do i have create a new asp.net user in sql server ? or what ? i have searched ...more >>

2005-11-18 12:50:12.09 logon Login failed for user 'sa'. 2005-11-18 12:50:36.85 logon Login succeeded for user 'NT AUTHORITY\SYSTEM'. Connection: Trusted. and some more that might be useful - 2005-11-18 12:50:40.92 logon Login succeeded for user 'NT AUTHORITY\SYSTEM'. Connection: T...more >>

Can connect with Windows NT authentication, but not with SQL server auth. So all my code has stopped working ... When I try to make a new SQL Server registration I get server does not exist or access denied... ...more >>

I just installed SQL Server on XP (SP2) attempted to access the Server through JDBC and got a error abut the socket connect. After much searching I find that the port is not active even though all app that would set the port have port 1433 set. If you follow. I ran netstat -ano and tasklist /s...more >>

Hello, Does anyone know an easy way to detect whether a LinkedServer is running without waiting for the TSQL statement to timeout? In otherwords, is there some secret stored proc or exe or some library that will allow me to write code to detect whether the LinkedServer is up and running wit...more >>

I installed SQL2005 as default instance. After that I installed SQL2000 with instance name "SQL2K". Then I installed SP4. I can'not connect to SQL2K instance from remote machine. But if I log on at machine on which SQL Server installed I can connect to instance. And I can connect to defau...more >>

I've just installed sql server 2005 enterprise on my Windows XP Professional SP2 machine. I can't find a way to connect with it. I'm totaly new to SQL Server and have installed it to learn about it. I can' t even find out if it is running or not. When I do a c:>netstat -a I can't find the po...more >>

I have a customer who's running an application that's using an OLE DB connection to the database and when retrieving records a counter shows on the screen. As soon as the count reaches somewhere between 3900 and 4000 the counting stops and the grid never fills. The message received is as follo...more >>

On Windows XP running SQL Server, how do I create a user who will be considered a "trusted connection? I currently have SQL server set up for Windows Authentication? Do I have to change this? Perhaps someone could list the steps to create a trusted connection. Many thanks, ...more >>

My application attempts to connect to an SQL Server database as name ASPNET and Login Name SERVERNAME/ASPNET in response to these commands: SqlConnection myConnection = new SqlConnection("Data Source=(local);Initial Catalog=MCSCRE;Integrated Security=SSPI"); myConnection.Open(); However, ...more >>

Hi, I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test it using telnet in port 1433, nothing happends. I need to connect to this server via Internet. How can I do? Leo- ...more >>

Hello, we are trying to migrate from SQL Server 2000 to SQL Server 2005. On an 64 bit Windows 2003 SP1 Server we have installed an SQL Server 2000 Enterprise Edition and an SQL Server Enterprise Edition 2005 (64bit), both as named instances. On both SQL Servers we have configured Ora...more >>

We have a linked server set up the same on 2 servers, but a query from one server executes different on the remote database. A Query from one server executes quickly, while the other causes table scans on the remote server, per Profiler. I couldn't see any differences on the query received on...more >>

Have a .net assembly, strong named, on an IIS box running Win 2000 Advanced Server (box is in DMZ). Web site connects to a Sql Server box (not in DMZ). The legacy asp app has no problem connecting to Sql Server, but when the dll is invoked in the asp app, and it attempts to connect to Sql Server...more >>

We updates the 2000 SQL Server to SP 4 and are getting the following error: Application error: cannot go remote while the sessions is enlisted in a distributed transaction that has an active savepoint source: microsoft OLE DB Provider for Sql Server Error code: -2147217900 Any ideas? Than...more >>

I set up a linked server between two SQL Server databases. I was able to query the linked database just fine. Then I deleted the linked server using Enterprise Manager. Then I re-created the linked server using Enterprise Manager but the original query (select * from [linked server name].[d...more >>

I've recently started to convert an old VS2003 project that was using some SQL2000 I now want to convert this project to VS2005 I've currently referenced: D:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll (Version = 2.0.0.0) AND: D:\Program Files\Microsoft Visu...more >>

Just wondering a few queries about the differences between programming SQL for MS Access, and programming T-SQL for SQL Server. 1. Is it possible to use the same general SQL statements/commands from a ASP page that was used with a MS Access DB, for a SQL Server DB? (Basically can you progra...more >>

Is ADP dying? ...more >>

i am looking for c++ libs so that i may connect to sqlserver..(user does not have client sql installed) thanks ...more >>

Can anyone tell me what the cause of the error below is? I have the client tools installed on XP Pro Svc Pack 2.0. When I try to connect to the server on the remote machine I get the error message below. I have set the logins up correctly for the user id I'm using on the client machine an...more >>

I'm not sure how this issue arose, but suddenly I keep getting an alert that: 'Windows needs your current credentials to ensure network connectivity' and requests to log off and log back on. I successfully establish a VPN connection and this error occurs when I open Enterprise Manager to conne...more >>

Hi, Where do I download the free edition of VS 2005 Express? Has anyone experienced problems with VS 2005 Express? TIA Roy ...more >>

Anybody knows the limit of concurrents connection of SQL Express Edition 2005? As I know, MSDE has begun to limit to 10 concurrents and extended to 25 concurrents for the new version, but I read the specification of Express Edition 2005, I cannot find the number of concurrent connection. ...more >>

Is it possible to find connection properties from within SQL Server ? I am interested in running a query (hopefully) that will return all parms used for any individual connection....more >>

When attempting to edit diagrams in Server Explorer from Visual Studio 2005 I receive the following error: This database does not have a valid dbo user or you do not have permissions to impersonate the dbo user, so database diagramming is not available. Ensure the dbo account is valid and e...more >>

How come I have to connect to my MSSQLSERVER instance using only "." or "<hostname>", yet it does not work with ".\MSSQLSERVER"? Yet all other instances require the host\instance format? This seems a bit strange and inconsistent. Also, the common dialogs should be: Server: <host> Instance:...more >>

Hi all, I just installed version 2005, and it is co-existing with an instance of 2000. I am trying to test the remote connection string from an ASP .Net page which works fine already in 2000. However it does not work in 2005. In 2005, I went to configuration Manager/Protocols/TCP IP, and e...more >>

hello, 1-I want a detailed step by step tutorial for installing SQL server 2000. 2- I want to install two SQL servers 2000 on the same machine, how could i do that? (i mean will there be any change in the installation to the second server?) 3- I want to know how to connect between these t...more >>

hello i want someone to help me in solving a problem in sql server 2000 considering that i have a table named PAY(TITLE, SAL) where TITLE is the primary key of this table also this table is related to another one named EMP, where the other table has a foreign key to this table. ta...more >>

I want to run a database creation sql script. The problem (I believe) is that I have to specify the database I wish to connect to when connecting to the server (ADO). Should I specify the Main database? Or is there a way around this?...more >>

Hi I have Sql 2000 Server Sp4 with two instances from some day the Sql server agent of second instance don't start and i can't do automatically backup. In Sql log i try Error 165, error odbc [sql state HY000] Can help me to risolve this problem. Tia pupo ...more >>

Hi there, I have a two Linked servers in a database. One of them is colocated in the same lan and the other server is across the country(California to Florida). We have a dedicated T1's(8 of them) between these two location. I have a stored procedure that decides which server to query t...more >>

Hi all, I just installed version 2005, and it is co-existing with an instance of 2000. I am trying to test the connection string fro an ASP ..Net page which works fine already in 2000. However it does not work in 2005. In 2005, I went to configuration Manager/Protocols/TCP IP, and entered 1...more >>

Hi, I have installed SQL Server 2005 CTP/Trial Version. When I try to attach the database 'AdventureWorks', I get the following error. Could not find row sysindexes for database ID 11, Object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes Could not open new database 'AdventureWorks'....more >>