You could use OSQL to run a script, where the script could be as big as you want ie:-:-

EXEC master..xp_cmdshell 'osql -E -S Servername-d master -l 100 -i "D:\script.sql" -o...

See http://msdn2.microsoft.com/en-us/library/aa173551(SQL.80).aspx

"Restoring a database using both database and transaction log backups works only if you have an unbroken sequence of transaction log backups after the last database...

If I ever alter the recovery model to Full from Simple the first thing I do is take a full backup, before even thinking of taking a log backup, simply...

Excellent that's just what I wanted.

Thanks

Not my idea but yes I've been asked to do just that, I know its meaningless but it's what they want to do.

How are you trying to enter the data? Are you inserting into the Primary Table first?

I want to be able to explicitly deny access to the full range of schema roles ie:-

ALTER ANY APPLICATION ROLE

ALTER ANY ASSEMBLY

ALTER ANY ASYMMETRIC KEY

ALTER ANY CERTIFICATE

ALTER ANY CONTRACT

ALTER ANY...

I am trying to deny access at schema level - Don't ask why!!! Your script doesn't list the permissions not already given, so I can't get the list from...

BEGIN TRAN

DECLARE @intErrorCode INT

--Some code

/* check to see if we had an error and if so goto the error handler and rollback the transaction */

SELECT @intErrorCode =...

Spookily enough I'm working on a security script as I write.

DECLARE @Database sysname, @sql varchar (max)

SET @Database = db_name()

SET @sql = 'SELECT ''GRANT EXECUTE ON...

ltrim or rtrim strips spaces L eft or R ight of the field

Look up Cross Tab Reports in BOL

Look at the space on the drive where your PRIMARY filegroup resides, and filespace on drive where the tempdb files reside.

I have seen this error before and it was because of other activity on the server at the time the backup was run, it could not find enough virtual memory...

Your syntax is wrong from BOL:-

SELECT au_fname, au_lname,

CASE state

WHEN 'CA' THEN 'California'

WHEN 'KS' THEN...