I may be wrong, but it appears that's a command to set a value to false so that when data is deleted it's not removed from the database. You...

2. Yes, but it's not worth it. Enterprise Manager makes it easy, but it's really:

Make a new table with the columns in the order you want.

Copy the data from...

LIKE means SIMILAR TO and accepts wildcards. [ can be used as a wildcard.

means NOT EQUAL TO

-SQLBill

Another thought...you aren't seeing errors in SQL Server's logs. How about the server's Window Event Viewer logs?

Thought....if you were getting TO the SQL Server, there would be login errors in...

Go to the server itself and try to log in using your credentials. You might have orphaned the logins when you moved the server.

-SQLBill

You are using a maintenance plan - I'll bet you have it set to reindex your database. BAD THING. Reindexing will grow your transaction log at a minimum 1.5 times...

You will also have to let SQL Server know how to interpret those dates. Is 1/3/6 - January 3, 2006 or 1 March 2006, or January 3, 1996 or 2001...

What does your restore command look like?

Also, you don't need to restore EVERY differential. Only restore the FULL and the MOST RECENT differential. Log backups are the ones that need...

Do you only want to find where all four items are the same?

SELECT *

FROM tablename

GROUP BY Firstname,

MiddleName

...

Using the ProductLevel will return just SP3. But ProductVersion lets you know if you have any hotfixes installed also. For example: 8.00.819 is SP3 + Q826161.

-SQLBill

Also, give people time to answer. Most of us aren't on here 24 hours a day. We check this site periodically through the day, so it might take a...

And yes, you do have to periodically check for updates.

-SQLBill

SELECT ServerProperty('ProductVersion'),

ServerProperty('ProductLevel')

That will give you the version (ie. 8.00.760 - which means SQL Server 2000 SP3) and the level (service pack) you are...

Another thing....you don't tell us what errors there are.

Look in SQL Server Error logs.

Look in Windows Event Viewer Logs.

Lastly, right click on the failed job, select View Job...

Is the job ENABLED?

There are two places it has to be ENABLED.

1. right click on the job and select properties. On the General tab, there is a box for...