did you reload sql databases on new server, meaning having another name?

IF so, first check BOL on sp_dropserver and sp_addserver.

You can also check msdb..sysjobs table. It keeps some informationabout the...

my first thought is something abot missing or changed sids / passwords / kerberos tickets on the domain controller. Did they rebuild a NEW domain controller ?

Have you tried restarting the...

first try to install SQL SP3a

JP

try gathering server, io and client statistics in query analyzer on both the server and desktop. This will show that the production server generally will be faster than the desktop.

Also...

Hi

If you have a corrupt page, u can find something in the sql server logs. Check EM, management, sql server logs for occurance of some kind of error concerning datapages....

HI

This is what u r looking for:

select isnull(Col014,7.45) from your_table

hth

JP

yo should try to figure out why the file is left open.

Do you cancel the backup command when it runs for more than 4 minutes ? What proces is...

Good article!

I use maintenance plans whenever possible. On some databases a maintenance plan fails during a reindex job (caused by a calculated field in a table). The real cause is...