Even better...go in and detach his database, then tell him his db is gone...it'll put the wind up him, may be then he'll get the hint

Tell him that anyone, and that does mean anyone can log into his server and do whatever the heck they want, from dropping all of his databases to removing all...

Try fully qualifying the shipmentsA table in the select @querystring.

Check that the open relay on the smtp server is allowing relaying from both SQL Server IP addresses.

Why can't you connect using EM?

You could alternatively remove paramters directly from the registry by deleting the relevant keys under

HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\PARAMETERS

To move the system databases (including msdb) there are certain trace flags that need to be enabled, see http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&sd=tech for more details.

I was having the same problem until someone told me that they were using a trigger on the msdb..sysjobhistory table to accomplish the failure notifications, I implemented it myself and...

You will need to start SQL with the Trace flag of T3608, this will only recover the master database and so will allow you to change the location of model....

All you need to have is an email server which will allow open relays from the server which you are attempting to send the mail from. Check the settings on...

Look to backup and restore the system databases on the new server from the old this will move across all logins and ensure that everything is as it was, you...

How about

SELECT TOP 1 g.GameName, gi.GameInfo

FROM Game G

INNER JOIN GameInfo gi

ON g.GameID = gi.GameID

WHERE g.GameID = 1

ORDER BY DateTimeOfThisPieceOfInfo DESC

You have relaying disabled on the mail server. You will need to allowing relaying in order for this to work, make sure that if you enable relaying however that you...

million, zillion years? that's quite a while...almost as long as it takes me to get up in the morning...

Is it just me, or...

How about this (test in dev of course)

DECLARE @update table (filenumber int, department int)

INSERT INTO @update

SELECT DISTINCT filenumber, department

FROM TABLEA where department is not null

UPDATE TABLEA

SET department = u.department

FROM @update u inner...

Does the department bear any relation to the file number?