I have an mdf that is 145 MB in size that had its corresponding ldf deleted. I have tried using enterprise manager to attach the database and tried using the attach single file stored procedure in query analyzer. Both methods fail with an error message that says that the ldf filename might...more >>

I have SQL Server 2000 running on a remote server, but can't seem to get connected to it. It is a named instance, and I opened that port and 1433 & 1434. I have them forwarded to my Server, but I still can't see the database? I can't ping the IP address, but I have a web site at the same addr...more >>

I am trying to work with a SQL Server database and there is no ODBC driver for SQL Server on this machine. I also tried to load a report writer that I thought would load the driver but I get an error that the CRSS file is missing in the registery. I did a search for CRSS and did not find...more >>

I need help! We have an SQL Server working with merge replication. My problem is that from yesterday some of the users recieve the error message: access denied or the SQL server may not exists. Can any body help me? Thanks a lot Lina...more >>

Can any assist on the following error. I have developed an application, that access the SQL server 2000.In this application I have coded the connection string as follows. "provider=sqloledb;data source=Sever Name;initial catalog=database name;user id=sa;password=system;" Then when I l...more >>

I ran into a serious issue in that the SQL Agent stopped for a reason we cannot determine. It is set to autostart on re-boot, and has worked fine for 8-9 months. Issue: Sql agent was stopped and backup were not being performed Question: Has anyone ever had a situation where the SQL A...more >>

I'm using the JDBC driver provided by Microsoft for access to SQL Server. I've run into a situation that I think is a bug and would like to find out if it is a known problem or if I'm just doing something wrong. I'm using a prepared statment like this: SELECT DISTINCT mycol FROM mytable W...more >>

I can specify the actual server name to connect to a SQL Server using Query Analyzer or DTS, but I am unable to use localhost or local. When do anything with server name, it is fine. Just not working with localhost or local. I checked hosts file content in WINNT\system32 \drivers\etc, ...more >>

the ntwdblib.dll when copied in c:\windows\system folder in a particular pc and when trying to access the server the same gives an error DB Library Layer not found.... kindly do help me out as to what can be done.....i have a feeling the ntwdblib.dll will be corrupt but the same is not ...more >>

Hi, I want to install SQL SErver on a Novell Netware and I want to know if anyone have some recomendations or observations. Thanks.. ...more >>

Hello I'm connecting to DB SQL server from my Access XP using DSN User, but on my network I have a proxy, so it's block my connection and I'm enable de connect, How can I depass a proxy to connect from Access to a remote DB SQL Thanks...more >>

I am running a ColdFusion web based application that excutes a stored procedure which creates a global temporary table. How long does this table exist in the database? I thought that it would go way after I closed my web application but it doesn't. Please help! Thanks. Derek Ruesch...more >>

Hi all, can someone help me? I=B4m trying to install a new SAP program on my SQL2000 SP3=20 machine. During the instalation the program seems that is not=20 connecting to SQL with 'sa' account. Sql is configured with mixed authentification. I logon sucessfuly with 'sa' account from Query Ana...more >>

Hello all experts! My problem is that I do not know how to create an Microsoft OLE DB Provider on my win98 client! My system: - SQL Server 2000 (client connectivity) on the win98 - (client-pc) - SQL Server 2000 on the server, Windows Server 2003 (server-pc) This is what I have done: -...more >>

Have you ran across this ? I need to send newsletters to users upon import of a daily batch of data to a sqlserver. I have created a stored procedure and a DTS package to perform this task using xp_mail. Questions: Is there a good SQL Server "plug in" out there that can be called from a st...more >>

I've run into a peculiar behavior of Enterprise Manager. It appears that when I run Enterprise Manager with a particular Server registered (based on TCP/IP address), it begins to port scan that server. I initially thought it could be virus/trojan activity, but I'm current on all Critical...more >>

Hello, I'm wondering what is solution with automatic correction for Daylight Savings Time? I'd like to convert from UTC (column) to local_time but with automatic correction when the time changes. Now I use just: Computed column: local_time AS DATEADD(hh, -6, UTC) or local...more >>

I'm trying to troubleshoot a SQL Server 2000 Developer edition install on Win2000 Pro SP4. 2 local accounts created for MSSQLServer and SQLServerAgent services to run under. The install seems to go fine but I cannot connect to the server in enterprise manager. It displays (Local) (Wind...more >>

I'm trying to connect a couple of users to SQL Server via Enterprise Manager. They can register one server okay but, when they try to register another, they get the "Specified SQL server not found..." error. One user is running WinXP and the other is using Win2kPro. The server they can see ...more >>

Hi, I am running SQL 2K I have a DB that is 6GB. out of that, 5.5GB is the Trans Log. I did a backup of the Data and the log. Now it shows 5.3GB unused, but I cant get that free space to go away! When I creaded the DB it was 10MB? so I know that is not the problem ...more >>

I am sorry if this message posted to the wrong group. The application that I am currently supporting deploying components via stored procedures. Latest Microsoft patches where applied, application stopped working. We configured new computer though operating system was installed by the outsourc...more >>

I am trying to create linked server for DB2 (which on Mainframes) without using HIS. Is it possible? ...more >>

We've recently purchased some latptops running XPPro. All work except one. When try to access my database I get the error: : "Database Error: Db-library network communications layer not loaded." All machines are the same as near as I can tell and the setup process was the same. Thanks, ...more >>

Hi All, I am having serious problem since last couple of days with my SQL server 2000 version. on one of my table I have 1788653 records and I am unable to manipulate data into it. whenever i tried to insert any more record, SQL server will give me error: ------------------------------...more >>

I was experiencing odd behaviour from SQL Server within Vis Studio this morning and had to uninstall SQL. Trouble is I can't seem to get it set up the way it was before. I installed the developer edition, client and server tools. Can't recall if I did this last time,but now I get the error: "A...more >>

Hi All, For some reason, it has become impossible to connect to any remote database servers from my computer. I can still hit my localhost databases, but I cannot get to any others via Enterprise Manager, Query Analyzer, or anything else. Prior to Yesterday, I was running Windows 2000 s...more >>

I have SQL server running on my Laptop under Windows 2000 professional under localhost. I am not able to open a connection to the server either through OSQL or .open() method. It gives me "SQL Server does not exist or access denied" error. I know that the SQL Server is running correctly be...more >>

Not sure if this is the right place, but I'll post here for now. OK, I have a customer who had a custom Visual Fox Pro database developed, and they are running SQL on NT4. They are having major problems when trying to run reports where it is taking HOURS to process. The database company t...more >>

ok, i'm getting this error while trying to delete a stored procedure. but the SQLSERVErAGENT is indicating that it has already started but this error message still appears.. what is causing this??...more >>

I'm trying to connect to a remote SQL Server 2000, using TCP/IP at my web host company. I use the Client Utility to make an alias, then I register a new server in Enterprise Manager. The connection doesn't work and I know why, the wizard never asks me for the IP address! What am I missing he...more >>

We have a datbase application that receives the following error: Cannot open default database '<ID>'. Using master database instead. This error happens inconsistently when accessing different parts of the database, and if you close the current screen and open it again you might not get...more >>

Is there a way to auto start sql service when OS starts w/out using sql server service manager? That is, via code. any help is appreciated jim...more >>

Hi, I have SQL 2000 set to use 256MB to 400MB of RAM, but if I go to the Task Manager (win2K) I can see that sql is using 438MB or RAM and 438MB or Virtual Memory. The box was rebooted a few hours ago. How can I stop the memory getting so high? Thanks. ...more >>

I have an Access application that connects to a SQL Server database. Several times a day I get a situaion where one user seems to be able to lock up the database, and until they exit the application no one else can edit any records. When I check the proces information I see hat that user will ha...more >>

Hi all. Can anyone point me to some example code or a precompiled extended stored procedure that I can use so that an SQL trigger can call a web page ? Thanks ...more >>

Hi, I have a client application written in VB, which is connecting to a SQL server 2000 database running on Windows 2000 server OS, using ADO. I am facing problem in connecting to the the database. The error i receive is "Specified SQL server no found". I restarted the SQL server. I am ...more >>

Hi I am trying to connect ti a database using em. The database tree shows 'no items' instead of the expected database tree. Any suggestions Eddie ...more >>

Greetings, can someone please tell me what does this error mean? xpsql.cpp: Error 997 from GetProxyAccount on line 472 I tried searching the knowledgebase but found nothing. Thank you, Pablo...more >>

003-08-18 09:00:29.95 server Copyright (C) 1988-2002 Microsoft Corporation. 2003-08-18 09:00:29.95 server All rights reserved. 2003-08-18 09:00:29.95 server Server Process ID is 884. 2003-08-18 09:00:29.95 server Logging SQL Server messages in file 'G:\Program Files\Microsoft SQL ...more >>

Hi.. I'm somewhat new to SQL2K. Is there a way to take all the current user tables (58) and create a relationship diagram without to much manual work? I want to print this out and study our table structure. Thanks George .. ...more >>

From ServerA (SQL7 SP4) i can link ServerB (SQL2K SP3) no problem But when i try linking ServerB\Instance (SQL2K SP3), i get "Error6 : Specified SQL Server not found" any way to work around this ? Thanks...more >>

I restored an early backup on SQL 7, only to find that users had been dropped in EM. I then restored a later backup which I was sure had all the users properly authorised, but they're still not there! What is the correct way to administer this? Is it by ticking the individual boxes for each ta...more >>

Hi there! DO you any idea why this error comes up? What should i do? "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query." I did try in my script ...more >>

Hi, Is it possible to attach a database without detaching it first? Thank you in advance....more >>

Is there some kind of database link in SQL Server that I can use to access an Oracle Table real time?...more >>

I have a connectivity problem with SQL 7.0. During light use there is no problems. During heavy use clients get a error message when trying to connect. "unable to connect to database. A SQL Server request resulted in a bad return code or status but no error message was returned. When a...more >>

Sorry for all the postings, but I've found something new. I tried a new DTS package, this one copying data from SQL Server to SQL Server tables (ie. No Oracle objects involved). I changed the properties of each step to set JoinTransactionIfPresent and Rollback Failure to true. When I run...more >>

The following SQL: begin transaction insert into ps_jrnl_header select * from ps_jrnl_header_arc_vw (ps_jrnl_header_arc_vw selects from an Oracle table using an MS OLE DB Oracle Linked server). Generates the error: Server: Msg 7391, Level 16, State 1, Line 3 The operation could not be...more >>

I need help to resolve this connection issue: Error creating database connection: Missing database information Page: /intratime/content/login.asp ...more >>

I've setup a Linked Server to an Oracle DB and have created a view in MS SQL Server to fetch data from the Oracle DB. The following SQL issues an Error: BEGIN TRANSACTION insert into PS_JRNL_HEADER select * from PS_JRNL_HEADER_ARC_VW Server: Msg 7391, Level 16, State 1, Line 3 The o...more >>