Yeah, it'll just create the jobs. We've used these scripts for years to migrate jobs to new instances and never had anything bad happen. You may want to...

You could just create it in master and when you run it use:

EXEC master.dbo.rr_Get_ForeignKeyTables @TableName = 'ttt', @DB = 'ddd'

I'm not sure what you mean when you say, "it wants to simply run each step...". When I script a job, whether it's on a SQL 2000 instance or...

I'm not sure. Run this:

EXEC sp_helplogins 'joa'

The database name returned as 'DefDBName' is the default database for the login. Make sure the login has a user in that...

How much space each instance requires depends on what you put in it. BOL states the minimum space requirement for each component. Add the space your data will...

select * from dbo.sysobjects where uid <> 1

I'm not sure what a .net membership table is, but this is what you need to transfer logins from one SQL Server instance to another: http://support.microsoft.com/kb/918992/. Sp_help_revlogin generates a script...

I think "State: 16" means the login's default database isn't available, either because it doesn't exist or the login doesn't have permissions to connect to it.

Here's one possibility:

select dateadd(dd, datediff(dd,0,Getdate()),0)- 1

select (dateadd(dd, datediff(dd,0,Getdate()),0)- 1)+ '23:59:59'

If this is a DTS package, Jack's BIDS suggestion won't work and, unfortunately, there isn't a way to copy a Data Transformation task in DTS Designer. Lot's of connections...

In SQL 2005, you'd use sp_send_dbmail and set the @file_attachments parameter to the name of the output file.

Yes, you can do that. All three statements will be rolled back.

I tried David's schedule also, but it just seemed like it took too long to get to that longer weekend.:P

If you want to make sure your database remains in a valid, consistent state, you shouldn't kill a session that is rolling back a transaction. In most cases, if...

I work in Washington state where the governor recently said that a 4 day work week is being investigated as a way for state government to save money. I'm...