what OS, SQL version.

I had the same problem.  If I remember correctly the problem was cause the the OS (Mine was Win2K server).  I will have to look back and...

doesn't really affect SQL server. You get that error sometimes when the server is to "busy" to give you the current activity. I think it's a problem with...

Here is one case when ee get this error. When ever we lose our network connection.  Our application maintains a connection to the DB when ever running.  If for some...

thanks Ed. This is not causing a problem, performance is quite good. I was just wondering if it was a good idea.

Question:  I'm using a SAN.  I put the data on the SAN but kept the logs and temp on a RAID 5 of the server.  Was this a good idea. ...

in addition to the permissions problem, if you are being prompted, the the job will appear to "hang".  sometimes when you run something like this through a job the system...

Like nyulq stated, but

Here is something to get you started:

1) depending on the database, you want to separate the data from the log.

2) if possible separate the O/S...

thanks David. I thought Raymond only wanted rowcount. The only time that I've found sp_spaceused to not report the number of rows was if someone was in a...

you can also run

sp_spaceused tablename

This can be done, by reading the syscomments table, however,

I had to do something like this before. I found it easier to script out all the SP each into...

Here is what I did for one of my applications: I created a READONLY, database with one table that holds a username and password, which is encrypted, using my...

I do have outer joins, and I proved that to be the case.  I just did not understand why.

Something else I discovered was that you cannot use a SP to...

Vladan thanks -- thanks for the quick response about the memory configuration. Please explain futher: I have 2 1G processors with 4G ram. What happens if i dynamically...

hi -- not sure if the linked server will support distributed transactions from the SQL side. I recently tried it with SQL7 to oracle and got some message about...

Not sure I understand and have always wondered this: SQL Standard can use a max of 2G, if th box has 4G of memory, how does the other 2...