I used set the parameter for timeout of query to 0.but con't no resovle the problem. Can you Help me? ...more >>

Hi there, I got SQL Server 2000 with SP3 in Windows 2003 Server box. I using domain account to start SQL services. Every time when I restart the server the SQL Sercer and Agent services cannot start. I must manually re-enter the domain user name and account only the services will start. ...more >>

Dear All, We encounter a problem where the SQL database transaction log grow dramatically and therefore affect the performance of SQL. We have a Database running on SQL 7.0 and Win 2000 professional using HP NetServer to serve a Client Server architecture application. In normal situation...more >>

hii... I am using SQL 2000 With sp3a on win200server. i am getting following error in application log. Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 10/31/2003 Time: 3:52:54 PM User: N/A Computer: BNET8 Description: Error: 17832, Severity: 2...more >>

(SQL Server 2000, SP3a) Hello all! We've got a development project that is using on SQL Mail (xp_sendmail) that we're moving to production . Our production environment is configured in such a way that we want to avoid using SQL Mail. I see a commonly recommended alternative is the xp_smtp_...more >>

Hi I have an SQL server, which (for some unknown reason) will not start as a service. Whenever it is tried to start (either using SCM, NET START, or Enterprise Manager), it reports the following error: "System error 1058 has occurred. The service cannot be started, either because it is ...more >>

I am constantly working with SQL 2000 at my clients sites because we are a Microsoft Business Solutions Partner. Is there any way for me to take Books Online and have it in a single help file or some system so that I have easy reference to it? I've tried taking the help files that make u...more >>

I created 2 databases and files in there in the same way ( as it seems to me). But one db has more system tables then the other one. Difference is in tables: sysfiles1, sysfulltextnotify, sysproperties Why ? ...more >>

sql2k sp3 Does anyone know of a very cheap way to set up a 2 server cluster for educational purposes? Ive already got the 2 machines but need some sort of data storage in the middle. Thanks....more >>

Is there a guide somewhere to let me decide on the size,speed, etc.. that needs to be purchased to run sql server on? There will be quite a few simultaneous connections and want to be sure I cover the needs without going overboard. Thanks. Tommy ...more >>

Hi, Can anyone advise regarding possible ways to search PDF files stored in SQLServer 2000 SP3 as binaries? Thanks and regards, A ...more >>

Does anyone have a method of tracing a clients IP address from the SPID available inside SQL Server to the sp_who2 command? ...more >>

hi all, iam trying to write a stored procedure to which i wanna pass an array of values ?, is it even possible, or can i pass a paramater collection or something ? -ashish ...more >>

Hello, I have a big problem with the performance of SQL Server 2000 on an IBM eSeries 335, with one Intel Xeon 2,4 GHz CPU and 1 GB RAM. As OS I tried: Windows Server 2003 Windows Server 2000 Windows 2000 Professional To insert of 6400 lines needs around 28 seconds. It doesn`t matter on w...more >>

Hi, We have AWE enabled but SQL Server 2000 with SP3 only use 103 MB memory during peak-hour. So we try to force SQL use 3GB memory. Is the following statements' order all right? sp_configure 'max server memory', 3072 reconfigure with override go exec sp_configure 'min server memory', ...more >>

Folks, I am having a problem firing a rather straight forward Trigger. It is duplicated here: CREATE TRIGGER DCED_Email ON [dbo]. [ContComp_Contract_TEMP2] after INSERT AS execute lp_pushtolive The user is one created using xp_sqlagent_proxy_account. The stored procedure (lp...more >>

Does anyone know how to get SQLDMO not to interpret ports as server instances? I presume this is due to named pipes being turned off on these servers. SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers(); This misbehaves for a SQL Server named instance that is specified as "s...more >>

Here is what I am doing right now. Proc1 CREATE PROCEDURE test1 AS DECLARE @VAR int SET @VAR = 10 SELECT @VAR GO Proc2 CREATE PROCEDURE test2 AS DECLARE @VAR int DECLARE @VAR2 int EXEC @VAR = test1 SET @VAR2 = @VAR + 100 SELECT @VAR2 GO This...more >>

I recently purchased SQL Server 2000 Developer Edition here in Canada. I mailed the registration card to the P.O. Box in San Francisco as indicated on the accompanying documentation. The post office has returned the card with a stamp that says "Box Closed: Forwarding Order Expired". As...more >>

We have a 3rd-party written application that was installed and has been upgraded on the same server. We want to move the database to a SAN, but it has a compatibility collation. The select serverproperty(N'Collation') command returns: Compatibility_52_409_20001. I have been reading about decodin...more >>

i write storing procedure and i need select column to determine order of result: CREATE PROCEDURE show_orders @prefix char(5), @lim_d int, @lim_u int, @ord char(20) AS select nr, data, nazwa_produktu, termin_realizacji, ilosc, odbiorca, status, stopien from zamowienia where (nr>@prefix ) and...more >>

How to do that when I have already created database which have database and log files on same partition. What I need is to move log file to another partition. Dubravko ...more >>

We began experiencing a problem with our sql7 instance running on nt4. For reasons unknown, we see a 1717 logged and the server goes down. I was unable to find anything in kb. Any info out there? Thanks...more >>

What's the difference between the SQL version packaged with SBS 2000 and SQL Standard?...more >>

I am supporting a new environment which is analytical not transactional. The logs are not dumped or truncated for the most part and as a result, alot of database logs are as big as their data files. a 145GB database has a tlog that is 45GB and mostly full. Aside from wasting space are t...more >>

I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper service was not started and set to manual. Is there a reason why this isnt started? Is it safe to start and set to Automatic on both nodes? Thanks, JBailey ...more >>

We are running a DBCC INDEXDEFRAG on a large table with a clustered index. INDEXDEFRAG skips the Compaction Phase entirely! What are the possible reasons for it to skip that phase? Thanks. --Scott ...more >>

Anyone know how to or where the instructions are for setting up SQL 2000 for SMS 2.0 usage is? I know you have to create the accounts in both the computer / domain and in SQL, but what rights do you give them, etc ? There used to be a "How To" article in the knowledge base, but that has all but...more >>

I would like to change the authentication method for an MSDE instance. How do I do it via OSQL ? This I need when there is no EM installed. I would like to turn the default authentication from Windows to Mixed mode. I searched BOL but it talked about using EM. Thanks in advance for your inp...more >>

hi, i just want the change the type of a column in a table within sql server 2000 enterprise manager. however it warns that, 'MyTable' table - Warning: One or more existing columns have ANSI_PADDING 'off' and will be re-created with ANSI_PADDING 'on'. - Warning: The table was created with AN...more >>

I'm new to SQL 2000 but here's the situation. We are going to be launching a major web site soon that uses SQL 2K as the database. What I'd like to find/purchase is software that I can run locally that will periodically synch my local SQL 2K database with the database being run at the hosting ...more >>

I've noticed that SUSER_SNAME() is not equivalent to SUSER_SNAME(SUSER_SID()). The first returns the string passed to the connection or what the user typed at logon, it does not lookup the account name. If I login as Darren, SUSER_SNAME() returns DARREN even if the account was created as dar...more >>

Hello! I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server 2000 on Windows 2000 server, during the upgrade I received the following error message " Error running script:messages.sql(1)". I found Microsoft article 300676 how to fix this problem. In this article they provide link to the n...more >>

Hi, I have a login that has access to a certain database, when i go to the logins session of EM to give the login acces to another user, i map the user with the login in a new database an i give him de db_owner role (Dev Host), when i do the ok or aply, i'm prompt to confirm the password....more >>

I have a server which has 4gig of memory. I have modified the boot.ini file to include the /3GB switch. I have looked at the process work set for SQLServer and it still appears to be using only 2gig's of memory. This server does have WIN2K Advance server and is also SQL Server 200 Enter...more >>

Newbie question: Importing a 25,000,000 record .csv file into SQL2000 fails with a disk space error. I go into sql enterprise manager to increase the size of the database and it will only let me go to about 4000 MB. I need about 30GIG. At 5000 MB enterprise manager says: Error 5149: Mo...more >>

Can you create a temp table ( # table ) inside of a transaction ? I'm a Sybase guy and know we cant do that in Sybase. It gives me a DTC error. Why do I need DTC for this ? TIA...more >>

How can I tell if I am running SP3 or SP3a? Thanks Emma ...more >>

We have a situation where SQL and IIS is loaded on the same server. This is a Quad Processor machine with 6 GB of memory. SQL itself seems to run OK. The problem occurs when there are multiple accesses to IIS to the database. Is there a way to make SQL and IIS play well together or is ...more >>

Hello: I have a server with almost 4 Gigs of RAM. Though SQL Server's memory config option allows me to allocate all of the available memory, I understand that Std. Ed. can only address upto a max. of 2 GB. So, I set this option to 2 GB and lo and behold, once the application floodgate...more >>

Hi All, I have a table like this : Product_No Field1 Field2 A 5 9 B 6 8 A 1 7 B 2 6 B 2 1 C 9 2 All rows can contain duplicate values. I want to access the first row of ea...more >>

Hi: What command do I use to strip an sql column of everything but numbers? Let's say I have values in my column such as "NX-383_H" and I only want the number portion "383" in the column but want to discard the other junk? thanks J...more >>

Hi, My company is using MS SQL 7. There is a database maintenance plan to do the backup. It sets the "Remove files older than 1 day". It used to work properly. Last week, I suddenly found that this remove function didn't work, and the files remain there for a whole week until the disk ful...more >>

Can anyone recommend a comprehensive guide to creating sql queries. Database maintenance is not a high priority at present. (for myself not in general :-)) The kinds of things I need to do are run reports against SMS databases for inventory reports etc. Thanks in anticipation...more >>

I have a number of reporting stored procedures that purely list records and make no changes to the data. I have noticed that some of these SPs are causing blocks so I am adding the WITH(NOLOCK) hint. For a simple example :- Select * from table1 WITH(NOLOCK) INNER JOIN table2 WITH(NOLOCK) ON t...more >>

Should data and log files be stored on different drives in SQL Server 2000. And should the backup files be stored on yet another drive? I have 2 drives available and have put the data and log on one and the backup files on the other. All of these are backed up to tape as well. Thanks....more >>

Hi, I have a question regarding the maximum number of concurrent users of MS SQL Server. If I use 5-user SQL Server, and already 5 users are connected to the server, and 6th user tries to connect to the server, then what will happen to the 6th user? Will he/she get an error like "connectio...more >>

Hello All, One of the users had deleted a table of records and I was asked to recover the table. The production database X, gets backed up Midnight at 12 and after that the transaction log gets backed up every 30mins. The table was deleted of all records at about 6:19PM (approximately) a...more >>

We've been experiencing above average "Log Shipping Restore" fails. All copy and restore can be worked for first two or three times. For no apparent reason, the job of log shipping restore fails. I checked the windows event viewer,the message is "SQL Server Scheduled Job 'Log Shipping Rest...more >>

Why do Mail notification in SQLServer works only with MAPI profile so if we need a mail notification we have to buy an office license so to have Outlook installed ? Can we use Outlook Express mail profile instead? Thanks Sopheat...more >>