I usually find the problem is caused by the exchange server being unavailable.

Stopping and restarting the sql server is the only way I have found to fix the problem

I find that adding in the 'nt authority\system' account in (as an admin) prior to removing the builtin\admin stops a lot of the pain with 3rd party backup solutions etc.

Thanks Frank,

I'll take a look

Steven

Note: the previous link is to the SQL Express beta, which is the replacement for SQL Server MSDE, hence no frontend etc.

Take a look at the 'sp_changearticle' stored procedure. This should let you remove a table from an existing publication (depending on your replication type etc)

There could be server side traces created and run be the sp_trace_**** set of stored procedures. (I usually kick these sort of traces off from a scheduled job.)

You could run...

It is best not to write dynamic sql as you need access to the tables directly, hence it is open to abuse from sql injection etc.

In saying that you can...

@@version tells you both the operating system patch level and the sql server patch level.

The sql server build level is displayed as a number e.g. 8.00.760 for SP3/3A

An updated list of...

Good article.

I have found that adding in the nt authority\system is a must, if you use enterprise backup software (brightstor or backupexec) as they don't log into the server as...

Again local admin access to every sql server.

(And of course I remove the builtin\administrator for each sql server, which means the domain admins do not get admin access to the...

I usually test backups by restoring them on a test server.

The other way would be to

1. backup the database (a must).

2. Detach the database (using EM or sp_detach_db)

3. Move the log file elsewhere eg d:\temp

4. Attach the database (using...

Trying check the permissions on the object using Enterprise manager, and see if anyone is denied access on the table

If I remember correctly there is a test button, which runs your code against the first 200 lines of data. Using that is a good way of testing your code

Also...

In the past I have used an active x transformation (ie vbs)to modify the date format ie change the / into a -