Hello! I have developed a software which uses DBLib to access SQLServer 2000. I tried if the same software will work with 32 bit version of SQLServer 2005 - there was no problem. But now I have a customer who has a 64 bit version of SQLServer 2005 and I urgently need to find solution for us...more >>

I would like to be able to perform a query where the database to query is a parameter. Can this be accomplished? I have tried various methods but none seem to work. Thank's Everybody...more >>

Our current program use ADO to connect oto SQL2000 and run fine. We are planning to migrate to SQL2005. When we clean install the SQL2005, create the database, set compatibility level to 80 and generate the db structure, and migrate data. When everything is done, we try to use our program...more >>

My sql server 2000 has install two instance,one is a named,some days before it can work well when connect to the database,but as the DBA has change the instance environment and I can't conncet to the named instance as follow instruction: "[Microsoft][ODBC SQL Server Driver][DBMSLPCN]δÕÒµ½Ö¸¶...more >>

Hi, The DBA set database on server to a high TCP port number. How can I connect to it from Microsoft SQL2005 management Studio. I can't find the option to set TCP port number in there. Thanks!...more >>

On a SQL 2005 server I have set the max user connections to 500 and restarted the SQL Services. The server is showing this as the current running value. However the user connections is reporting over 30,000 and sp_who returns over 150 with the majority of these listed as sleeping. Why is th...more >>

in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last ...more >>

I have a SQL 2000/2005 server (2005 is a named instance, 2000 is the default) which I can no longer connect to from remote machines using Management Studio (or any app that uses the Native Client). Further, I can connect to the 2000 instance using Enterprise Manager or Query Analyzer. O...more >>

I have a scheduled task that runs a batch file in windows 2003 server which is running SQL Server 2000 Enterprise. The batch file contains the line: OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log the 'myscript.sql' file updates a table with another table of the exac...more >>

Here's a problem that I can't fix. I have an application that uses a SQL database. The connection is made through ODBC. Also this application uses the same username for all the connections; yes it's one of those. Now this application generates a blocking in witch one spid is in the head of t...more >>

Dear ALL, my environment is SQL 2000 SP4 on WIN2003 Server Standard. In enterprise manager, when I have to create a new sql registration, on a server I can see (local) instance, on the other one NO !! Server are the same, (HP Proliant DL380) , please could anyone of you give me an he...more >>

Well like everyone else, I see folks moving to simple recovery mode for their SQL databases and making more daily "full" dB backups. So now that I have moved from full to simple recovery mode. I still have all these transaction files killing me in space. Like 77GB! I don't think I can dele...more >>

Hi, We have a 33GB database on Windows 2003 RC2, SQL Server 2005 SP1 on HP585 AMD64 bit with 4 CPUs, 16GB RAM and 3 disks on storage array. Our five web server connects to database and queries database. The problem is when we make a request on a web server, it generates a query and execut...more >>

I have placed a Windows 2003 server, running SQL Server 2000 on a DMZ that is on my internal network. I understand that as a Windows system starts, it advertises its services through Service Advertising Protocol, which allows client computers to browse and select servers of a particular type ...more >>

Hi, I'm trying to call an Oracle stored procedure from Sql server and I have this error message Could not execute procedure 'INTEGRE_INTERNET' on remote server 'ORA_DEV1'. [OLE/DB provider returned message: One or more errors occurred during processing of command.] [OLE/DB provider returned...more >>

I am experiencing an error message when I run a TSQL and I don't know how to correct it. Server: Msg 8115, Level 16, State 8, Line 38 Arithmetic overflow error converting numeric to data type numeric. In this code I am extracting hierarchical information. I am going 6 levels deep. The s...more >>

I set up a package with runs from a batch file on my computer after creating the script with DTSRunUI. I cannot run it on another computer. Do I have to copy DTSRun.exe to the other computer with the related rll files to get it to run ? Is there a recommended way to do this ?...more >>

Hi All, My issue like that.... I have SQL Server 2000 enterprise edition installed as named instance. I have configured mixed mode authentication also. But the problem is whne i try to register my sql server usuing windows authentication i get the following error message " Login failed f...more >>

I have a SBS2003 server that required a re-install of Sharepoint. I had 2 databases that are part of a document locator application, the application made its' connection using sa and the associated password. I removed and reinstalled Sharepoint and upgraded the sharepoint instance to SQL std ...more >>

Hi there! I have a Sql Server 7 running on a webserver. Now I have a quite complicated query that I run on 4 ways. 1: Using ODBC-driver directly on the Sql Server. time to execute: 12 seconds (done this about 10 times) 2. Using OLEDB-driver directly on the Sql Server. time to execute: 12 ...more >>

I just bought a book that I thought was about the SQL query language. Turns out it's really about mySQL. Uh. What is the difference between query language for mySQL and MS SQL? Is there a good reference? Vic ...more >>

Hi, I've just done my first install of SQL 2005 Express and am having problems connecting from a remote workstation using a VB6 application that I believe used OLE DB/ADO. I did get the application to connect, but only by installing an instance on SQL Express on the remote workstation. I r...more >>

SQL 2005, sp1 on win 2003, sp1. while starting a named instance, getting error : ERROR : The Service did not respond to start or control request in a timely fashion. I can NOT see those new ( 2#) named instances in "surface area config" where as I CAN see them in "surface area configfor...more >>

Just a few days ago, we changed the password on our server. After that, I noticed that I could not open Query Analyzer from within Enterprise Manager. I can open Query Analyzer from the start menu and login that way, but can someone help in where to look to make it be able to open from with in...more >>

e.g. in an local area network.. server = 192.168.0.1 me = 192.168.0.2 i just simply using Windows Authorization, then it could be abled to login as an admin through the Studio Express.. ( do anything i want) how can i setted it to disable those login from network ? a bugs ? i have ju...more >>

We have a couple of Bill of Material tables in our SQL 2000 database and I need to extract information. The first table is the master table and the only relevant field is fpartno. Table two is the child table, and it contains all of the parts that make up the fpartno in the master table. Th...more >>

I need to combine data from two different tables on two MS SQL servers running on the same LAN into a single SELECT or VIEW. Is this possible and what would the syntax look like? Thanks, Charles MTS, Inc. ...more >>

I would like to connect to MSAccess 2003 database from a SQL 2005 database. I tried using Linked Server but it will not work as my MSAccess database is on a different server. I am also trying to use OpenDataSource but I am getting an error. SELECT top 100 * FROM OPENDATASOURCE('Microsoft...more >>

All Anyone know what is truly recommended for the NIC settings for SQL 2005 when installed on Windows 2003? Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be set to: "Maximize date throughput for file sharing." However, MSDN article states that the setting shoul...more >>

Hi... On a remote server, I have SQL 2005 installed as the default instance as well as a new named instance. From SQLCMD, I can connect to both instances. However, from Management Studio, I can only connect to the default instance. Is there something special I have to do to connect to ...more >>

I'm having trouble getting a new linked server to work. Server Mfr is 2005 Dev (sp1) and is the 'local' server. Server Krypton is 2000 EE sp3 and is the target server I need to link to and query. I have a valid Windows login on both systems and I'm in the sysadmin group on both servers. Af...more >>

Hi, I have SQL Server 2000 Client installed on Windows XP and SQL Server 2005 Database on Windows 2003 which is not on domain. I want to access SQL Server 2005 database from SQL Server2000 Client. When i am trying to connect it, i get access denied error. Is it possible to connect...? ...more >>

I have read all I can find and am just frustrated... Our system uses SBS on a company network and Server 2003 for our web server that is not in the company domain. I am developing a web based system with VS2005 Pro. I can connect to SQLServer Express on my computer running on localhost. ...more >>

I'm running an access application on my local server (SQL Server 2000) On my win 2000 it worked perfectly. On my win XP, I always get this error message : 3151: ODBC--Connection to 'MyODBC' Failed. This happens when I want to run a procedure that fills a table with records from other tables....more >>

Hi, I have 2 nodes SQL Server 2005 Ent. 64 bit SP1 cluster on Win2003 R2 Ent. I would like to connect via SSIS to an Oracle DB. I don't get any Oracle data providers on the list of providers. When I try to use one of the MS providers like MS OLE DB for Oracle I get "Oracle client and networ...more >>

Dear experts, I hate to ask such a seemingly dumb question. But I have spent some time trying to solve this already to no avail. When I was using my query analyzer last, a few months ago, I was tuning some strange code. I changed some settings to see what was going on. Now, when I logi...more >>

I think I have done my homework and research on this. I'm in a company Intranet and through Enterprise Manager, I have added the server I want to access (FES89TXNCEV501) in my server group. I can access the that server and open a view on that server (read only). I want to write a query (see be...more >>

I am not a programmer nor a developer. I just want to get familair with SQL administration stuff. I knew there is no enterprise manager in SQL 2005. Which new tool did replace the enterprise manager?...more >>

Dear experts I have a customer requirement. App is a C application deployed on Solaris. The database is inteded to be MS SQL SERVER 2000 or 2005. Before I even get started, will Microsoft support such a mix - i.e., connecting to SQL Server from unix. Does a supported driver exist? ...more >>

Hi, Is it possible to have an SQL Server NOT broadcast the fact it's an SQL Server? In a school environment, with Visual Studio 2005, this product gives the students a mite too much connectability to network resources. Would it be possible to have a 'passive' SQL server? One that doesn't ap...more >>

Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine. Then I installed application on production server. Database is placed on another server. I received the error: An error has occurred while e...more >>

Hi. I have installed Microsoft SQL Server Desktop on Windows Xp Pro. I can connect to database from remote machines with Windows 98Se, but i can't connect from machines with Windows XP. Chris ...more >>

I have sql 2k5 installed (developer ed) on my advanced server 2000. It allows remote connections. I'm trying to connect using sql authentication. The server is not a member of a domain. I try to connect from an XP system using an IP number, sql user and password. The attempt fails and the e...more >>

Hello: When I try to connect to an instance of SQL 2005 in Management Studio on my laptop, I get the following error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the de...more >>

How can you enable connection pooling from an application server that connects to a SQL server on a different server? ...more >>

Pardon if this has been asked before. If so, please post the URL. Could someone please tell me how to fix this login/pipe? Notice the 3rd login is fine with "/E". It is a SQL2005 Enterprise on Win2003 Server Ent. C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin>...more >>

Just downloaded & installed SQL Server Management Studio Express on my desktop as part of SQL Server 2005. I can see how I can view my database tables, and columns in the tables. But is there a GUI-type interface to view the data database, like Access has? Vic ...more >>

In VB 6.0, (sp6), using sql server 2000 (sp2), and ADO 2.8 the following code keeps crashing when I get an error. If mconTheConnection.State = 0 Then strEmailBody = strEmailBody & "The program was unable to establish a connection to the database " & mstrDataBase strEmail...more >>

i am using an OPENROWSET method to import from excel data to sql server. i am getting an error like ADO error:[OLE/DB provider returned message: Operation wa canceled.] OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitializ Initialize returned 0x80040e4e Could not initialize data source ...more >>