Balaji,

You may want to check out Q267953 to see if this meets your conditions as well. This is an apparent bug in 2000 under certain conditions. Worth a look anyway....

Besides running SQLServer 2000 can you give more specific information like amount of memory on box, is SQL running on dedicated memory or dynamic memory allocation. You wouldn't by chance...

That proc is undocumented but, if you just run it as is i.e. xp_fixeddrives it will return something like as follows;

drive MB free

C410

D1271

E10356.

Don't know if there are any...

Bill,

Your boss is right and what a perfect opportunity to get control of what is going on in the databases. Normally you as the DBA have to force this issues...

I'm assuming you would be passing in @tabName so, you will need to change this some however, a working variation is below.

declare @qry nvarchar(500)

declare @qry1 nvarchar(500)

declare @tabName nvarchar(50)

declare @x int

set...

Just thought I would finally close this post out! We found that the issue is with the MDAC version that was used in the ODBC connection to the database. We...

PattiKay,

Check out article Q255097 from Microsoft. This is apparently a known issue however they do suggest a workaround. Hope this helps and have a great day!

David

Wes - Long time since you have posted. This is something that can't be answered specifically as there are too many variables to include such as processor, memory, server activity,...

Jay,

After reading your post and struggling with this on several occasions in the past I did some further reading in BOL and found this in the Checkpoint Topic. I thought...

I too was going to offer the same deal but, if I had my choice between me and Steve, I know I wouldn't choose me. Hope this works out well...

Joe,

Does the account that is logged on to the Server you are installing SQL 2K on have Local Admin or Domain Admin privileges? This may sound like a dumb question...

Joe,

We have done numerous upgrades from WinNT 4.0 to Windows 2K and subsequent SQL Server installs following that with no problems. So, I don't believe that to be the issue....

...and now that we have all the technical aspects of this job title defined, a DBA must be the type of person that is approachable above all things to be...

Having the users workstation in AD would only be necessary if you are going to manage that computer with Active Directory so, no the user workstation would not have to...

Kevin,

There is an article on this site http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp that covers the options here rather well. One question and excuse my ignorance but does 6.5 run on Windows 2000...