Because he is not inserting the table owner name. If he used master.dbo.sysprocesses then he wouldn't need the double '..' DBO is assumed if the owner(schema) not specified.

Hope...

Lou!!! Tell me about this feature of cutting and pasting...please. I have been needing this forever and couldn't find any way to do it.

BTW, I live by Terminal...

Make sure you don't have the datatype bigint in your SQL table. Also check that any bit fields have a default value and that none of the records have...

sp_msforeachdb 'use ?;exec sp_dboption ?,''autoclose'',''false'''

This will do it. You get errors about the master and tempdb, however, it appears to work on the rest of the databases.

I haven't used it yet, but I found 231619 at support.microsoft.com that talks about how to use the SQLIOStress Utility to simulate I/O on your server.

Michelle

srvinfo comes with an Operating system's resource kit. I found it in NT 4.0's copy but found references in more recent kits. Unfortunately it isn't one of the...

Make sure the first row has a value in that column. DTS seems to use the first row to generate the structure and if doesn't have some value, then...

I've seen it. I have had it. It is very hard to troubleshoot and I don't have much info for you.

Check to see if your machines have distinct identities...

We take a different approach. I reboot weekly. Every Friday night I have a 4 hour window when users know the SQL Servers won't be available. I...

sp_serveroption @server = 'SERVERNAME'

,@optname = 'DATA ACCESS'

,@optvalue = 'TRUE'

Execute this on the machine you want to remotely access.

sp_msforeachdb 'use ?;insert into server.db.dbo.database_files_FOR_BKUP exec sp_helpfile'

GO

My understanding is that you must use the select statement in a string and then execute the string. So your code would look like this:

USE fai

Go

DECLARE @SearchWord varchar(30)

DECLARE @cStr...

I have received these messages when there is too much of a load on the server and it is about to crash. Seems like the Server cannot get the...

I liked the test...I'm disappointed in what I don't know...but I keep learning everyday.

ON the question 14 about changing your SQL Server login's password, I chose the wrong answer because...

I'm not good with HTML, so I sent the pictures via email to you. Does this help?

"Hope this isn't too big for your email, but I don't really know...