Hi, I have install the SQL Server 2k Eval version on a Win2K computer and update to SP3. the computer also running the IIS too. When I install the server tools of SQL Server 2000 CE Edition, I got the following error message:- "SQL Serve CE Server Tools is compatible only with SQL Server 20...more >>

I am running SQL 2000 SP3 on a Windows 2003 server. I am having problems with pauses in my application software. I put a protocol analyzer on the switch and I am getting no data error but I am getting a large amount of SQL retries. It this normal? Has anyone seen this problem before? ...more >>

Hello ; We are having problems installing our desktop Application at a customer's site where the policy is to disable the Server Service. Being a desktop configuration, our installation places MSDE on the same PC as the rest of the application. Unfortunately the installation will not succee...more >>

Dear all We have one live server. We are not able to connect to the server neigther thru Enterprize manager nor thru Query Analyser. This is a strange issue we are facing. This server is installed 3 months back. We did not face this issue till now Actually, the port 1433 is enabled when we in...more >>

Running SQL2000 on Windows NT. Using Enterprise Manager I have registered a new server. When I register the server using the wizard, I set the authentication to Windows. This allows connection using Enterprise Manager. For a number of reasons I want to change the authentication to allow '...more >>

Hello, I am using xp.and my user was deleted. I create new user.But now my database seem suspect.How can I get back my database Thanks.. ...more >>

Several DTS packages that use (local) as the server name in the ms ole db providor for sql server suddenly broke. They'd worked well for years. The existing connection using (local) won't find the default instance on the machine. A new connect using (local) works file. SQL Server is 2k...more >>

Hello, I am using xp.and my user was deleted. I create new user.But now my database seem suspect.How can I get back my database Thanks.. ...more >>

friends, can i get some information (links , etc. ) on database connectivity strategies (TCP/IP, ODBC , etc.). Thanks in advance. ...more >>

I got one sql server connected to 5 workstations,A small vb application which updates 10-15 fileds,submission of each record is taking 35-40secs,we will be updating 50 records at a time span of 30-45 minutes. Here the time taken to update each record is pain taking. How can i over come t...more >>

I would like to using upsizing wizard in Access 2000 to convert an Access database to a sql server database. When I ran the wizard, and hit next button it gives error message: overflow. Then I update office Office 2000 SP-3 according to ms site knowledge base article 272384, but still ge...more >>

I have Windows 2000 client that can connect to a Sql 7 server via Db-Library and TCP/IP without problem. However, this same machine can ONLY connect to a SQL 2000 via DB- Library using named pipes. If TCP/IP is used the following messages is returned ....... SQL SERVER MESSAGE 18452, stat...more >>

When Connecting to a SQL Server Database from a single Client computer getting the error General OLE Error :16386 Cannot find anything on this through the knowledge base, maybe someone out there can help. Worked up until 2 days ago, nothing was loaded/unloaded on the computer all ot...more >>

http://www.microsoft.com/sql/reporting/productinfo/trial.asp If you have a SQL 2000 license, you can use the software. I don't work for Microsoft, but I am excited enough to see this that I wanted to send out the link. I have been waiting a long time to move beyond the limits of Infomaker or...more >>

Hi, Is it possible to execute a query asking for joined data from different tables on two different servers and databases? SQLServer1 SQLServer2 ------------------- -------------- 09.0.0.30\TestData 198.160.30.20\TestData2 I need to run a query aga...more >>

Hi all, I have the the problem with logging to MSDE using SQL-DMO interface. On the W2K with LoginSecure=TRUE everything is OK (connect is made without any parameters) But when LoginSecure=FALSE connect( 'instance_name', 'sa', 'sa_password' ) it returns error message : Login failed ...more >>

Hi I am occasionally getting the above error from an ASP.NET application that inserts documents into a SQL database. It had been running without this problem for several months and suddenly this problem has raised it's head twice in the last few days I have narrowed it down to happening when doc...more >>

I am trying to connect to a SQL Server 2000 database, running on Windows Server 2003, from my development PC, running Windows XP Pro, using ASP.NET. My ASP.NET application runs fine until I try to connect to the database, at which point I get the following error message: ------------------------...more >>

I'd like to keep track of the number of logins to a SQL server over a day which are then logged in a simple text file, for licensing reasons. What do you think is the best way to do this? I was thinking of using a trace but fear this may generate too much info. Could I schedule a stored procedur...more >>

I have an asp page that at one time worked. Now I get the below error msg. It only happens on my asp page. I can run through access or vb and it connects fine. It also works fine through a dsn. I have looked everywhere to no avail. it is sql 2k sp 3. any help is mucho appreciated Microsoft ...more >>

Hi, When I install MS SQL 2000 Desktop Engine on a win2K computer, I got an error message: "The instance name specified is invalid." and then cannot proceed. Why ? Please advise how to solve the problem. Regards, Derek ...more >>

After doing netstat -na, it appears that sqlserver is listening on all tcp interfaces. What configuration you need to change so that sqlserver could listen on specific interfaces? Thanks in advance ...more >>

Hello, Running Cold Fusion and just started to get an error where I have not in the previous few years. Cold Fusion stops serving up database driven templates but will continue to serve those that do not use the sql server 7 database. The error I get is: Error DiagnosticsODBC Erro...more >>

I have a pretty typical configuration: I have an ASP.NET program running on a web server. The program accesses SQL Server database located in another domain somewhere in the other end of world. I know the domain's name and I know that the database server is published out by the domain's ISA serve...more >>

I´m randomly getting the following error in my development environment: error '80004005' [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite(WrapperWrite() My platform is: Windows 2000 Server SP4 + SQL Server 2000 I´m developing a 3-tier system, using IIS 5 and VB6-gene...more >>

If SQL2K is not listening to the standard ports because 1433 has been changed to 14000, then what should the connectionstring in as ASP page look like so that it uses the correct port in order to make the connection? object.ConnectionString( "Provider=SQLOLEDB.1; Data Source=MyServer; Ca...more >>

Hi, I've successfully created a connection (linked server) in SQL Server 2000 to an Oracle database (9i). I'm running SQL Server on a WIN2K machine. Now, I know that the connection is made because I can see the list of tables and views under my Linked Server. With that said, if I try...more >>

Hi, I am trying to exec a Oracle Package / SP from my sql server. However I get error: Server: Msg 7357, Level 16, State 2, Line 1 Could not process object 'EXEC EPROMS.pg$es_get_apo_info_s.SP$AP_GET_APO_INFO('12 Nov 2002', '12 Dec 2002')'. The OLE DB provider 'OraOLEDB.Oracle' indicat...more >>

Hi To all, I am facing a strange problem. I used to have an excel file that extracts data from one of my SQL servers. with some filterings. A week ago, some problem happen to the SQL server the ntldr problem (which i have solved by reloading the files into the server)which is back to no...more >>

Greetings, Is there any way to detect when a user connects to my database? I mean, I want to know when a user connects to my database and when he/she disconnects, and do something when this happens (a trigger, I guess). Any ideas?? Thanks! ...more >>

Hi, I've successfully imported data using DTS from an Oracle Database to SQL Server. Now, I'd like to write a SP that will be called periodically to append the "new" rows of data that were added since the last update. I have no idea how to code a remote connection in a SQL Server Stor...more >>

Ok, I'm trying to Link to an MS Access DB on one of my networked drives using an ODBC connection. It works, and I can even view the queries within the Access DB. The problem is that when I use them in a View or something I keep getting an error that the DB doesn't contain the Table or Vi...more >>

We are trying to pull information from a SQL 2000 table using a fully qualified path in SQL 7.0 SELECT <server name>.<database>.dbo.<table name> My question is whether or not SQL 7.0 can select from a SQL 2000 table. Thanks, Carey Oshel...more >>

I have SQL Server 2000 installed, client tools only. I can access the SQL Server on my network and various remote SQL boxes but I cannot register a local instance. I keep getting the "SQL Server does not exist or access denied error message". Any advice?...more >>

Our application uses Embedded SQL for C to connect to MSSQL: EXEC SQL CONNECT TO :db_str AS :db_user The application runs on the same system as MSSQL server. The customer complains that if their server is busy, then the application can not connect to the server. Questions: How to incre...more >>

I'm relatively new to SQLServer. On one machine I have Access 2002 and the Developers edition of SQLServer 2000 and the Upsizing Wizard works fine. On the other machine I have the same version of SQLServer, but Access 2003. No matter what I have tried I can't get the Wizard to connect to SQLS...more >>

Which ports are default used to access a database over a vpn? I have opened 1433, now I get the message that it can't login. Are there more ports which need to be open? Thanks. ...more >>

Hi All,. I am a total newbie to this but have been asked to research a few things regarding SQL Server. Can anyone please answer this question: If we were to develop a web front end to perform queries on an SQL database, can we effectively give 1000 users concurrent access to the SQL data...more >>

I am trying to access data in a SQL 7.0 database via SQL Enterprise Manager 2000. When I right-click on a table and select return all rows, a message appears with two messages: "[Microsoft][ODBC SQL Server Driver][SQL Server] Changed database context to '<database name>'" and "[Microsoft][O...more >>

We would like to connect the remote SQL Server using Enterprise Manager of our local SQL Server. As everytime a small DDL modification has to be made we have to exchange .mdf & .ldf files. I would like to know all possible options to solve this problem....more >>

What are the conditions to connect two SQL Server together via Internet? I need to run a DTS job which copies some data from a table in SQL 1 and sends it to SQL 2. Thanks. ...more >>

Can any one suggest me the best way to connect to a remote SQL server using the internet. The option that I know is: Use of remote IP address to connect. Is there any other options availabe to access the SQL server like using ASP pages or some thing else. ? I want to ensure that the connect...more >>

Hi, I have a SQL Server 2000 database. I want to copy the database to a different SQL server 2000. The destination sever does not at all have that database. How can I copy the database schema and the all the data stored in the database. Any help regarding this will be highly appreciated. ...more >>

Basically, I want to 'link' the tables for record modifications, entries, etc., so that the client (within a WAN) has the GUI front-end that he/she is accustomed to (Access). ODBC seems old and slow, and I wanted to try something new - ADO/ADOX/OLEDB? Is there an easy way to make the connection, i...more >>

We would like to have SQL connect with an Access database over a WAN. Is the best way to use MSDE and allow SQL to connect directly to the Access database or to convert this database every so often to SQL? Thanks! Ernie Adsett ...more >>

We are developing with SQL 7 Developer Edition and planning to install MSDE with the VB application. We received the following question from the IT dept. of our client: "Does your version of SQLServer database work well across a frame relay wide area network?" Should there be any proble...more >>

Is there a character limit on the size of the string that can be passed through to SQL? It appears that when I try to send a string of approximately 15,000,000 bytes, the first 109,000 bytes or so are processed. The rest is ignored. However, no error occurs, and the value returned from...more >>

This occurs when I try to add an Item in the basket in my Online-Store I am using Visual.Studio.Net and data stored on SQL Server 2000 Why am I getting these errors and what can I do to correct them? Thanks! ---------------------------------------------------------------------------- -----...more >>

Can someone please help me with this problem. I Did a database backup from serverA and restore to serverB using w2k. I detached the database from serverB, and when try to attach to the restored database, I got an error" Error 9003:The LSN(120998:148:1) passed to log scan in database "xyz" i...more >>

SQL Server 2000 Enterprise Edition clustered on Win 2k Advanced Server Last week we installed the Oracle client 8.1.6 to allow DTS to extract data from our Oracle Financials system, which has been working fine. Since then users have reported poor performance. Performance monitor showed low (20-30%)...more >>