I have not been able to do this without creating the table ahead of time.

try this link. http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&Product=sql

if you can send mail successfully, check which account SQLServer and SQL Agent are running under. They must run under the domain account not the system account.

we are using PB with SQL on a WAN and get this whenever the connection is lost between the PC and the server. Our app was not designed to...

We have a small DB 25G. I have found that I get better performance when I update the statistics. so much so, that I now update every night.

Curtis Smith

Application...

Agree with above: to expand on gmlucas, I appointed a junior DBA to release to QA. Each developer works from his own "sandbox" and there own DB. ...

The problem is most likely, you are using the SQL 2000 Client tools the hit SQL 7 database. This will not work.

Curtis Smith

Application Dev. Mgr

DBA

If you've looked at everything else. Try this. We had the same problem. It turned out to be a pif file. Not sure if was meant...

funny thing. I renamed the database and the problem went away. I name it back and the problem occurs again.

Curtis Smith

Application Dev. Mgr

DBA

I am getting the same error on Win 2003 / SQL2000 SP3a. not sure what the problem is but it seems to be with only one database. database...

the problem isn't with dropping the table, and I'm not getting an error. performance just slows down. [will check for recompiles, though] I have two SP's that basically...

good tips. what about personal edition. does anyone have a method for finding them on the network. some of the MS wizards find them.

Curtis Smith

Application Dev. Manager

http://www.PSAKIDS.com

Hi I've been having the same problem on a 4 CPU system. Two things I found:

1) We have a heavily used SP that returns varying number of rows, sometimes...