This fix is at your own risk. I have never had a database come back suspect or corrupt becuase of a reboot.

I have however had to wait a couple of...

Did you receive any error messages when you backed up the database?

When I run into that situation I reboot the server.

When i restart I start SQL in single user mode and let the databases recover then restart in normal mode.

There is software available to monitor services and page you when they go down.

I use What's Up Gold for monitoring the SQL and Agent services on my servers. It is...

exec sp_help tablename

The N is for Unicode

Here you go, try this:

--Get default values for all objects in the database

select object_name(sc.id) AS 'Table Name', scol.name AS 'Column Name',

object_name(sc.constid) AS 'Constraint Name',

scom.text AS 'Default Value' from...

How about something like this:

select

CASE PATINDEX( '%[a-Z]%', col1)

 WHEN 0 THEN

     stuff('000',4-len(col1),len(col1),col1)

 ELSE

  stuff('000',4-PATINDEX( '%[a-Z]%', col1)+1,len(col1),col1)

 END

from test1

Where test1 is the table in question and col1 is the column you...

I do not know of a way to execute T-sql when you create a stored proc.

You could however, run a job periodically that looks at the create date (crdate) in...

On my servers the only reference to backup locations is on the SQL Agent job itself. Backup database 'databasename' to disk='backup location and file here' with init.

With the database set to Simple deletes will still be logged, but the log will be truncated upon completion of the delete. If you work on smaller sets of data...

If the old server is no longer used you could map the DNS name of the old server to the IP address of the new server.

This would only be possible...

Why don't we just post the answer in the forum for those individuals who look here first?

Do sp_hexadecimal and sp_help_revlogin both exist on your master datase?

Equivalent of truncate = non-logged process to empty a table (worksheet in this case)

drop and recreate meets the requirement IMHO