Doh! Copied the wrong thing. Here you go:

create proc sp_kill

  @dbname varchar(100) = null,   -- When specified, kills all spids inside of the database

  @loginame varchar(50) = null,  -- When specified, kills all...

The only ways to clear out (truncate) the transaction log are:

1) transaction log backup

2)Backup Log ...with NO_LOG | Truncate_ONLY:

NO_LOG | TRUNCATE_ONLY

Removes the inactive part of the log without making...

Sorry I didn't include it the firt time around:

Use master

go

exec sp_kill @dbname='dbname'

Use master

go

alter database dbname

set SINGLE_USER

Sure,

     Steps:

     1) Backup Database (Execute SQL Task):

USE dbname

GO

BACKUP DATABASE dname TO budevice  WITH INIT,

   NAME = 'backup set name'

GO

     2) Kill users in destination db (Execute SQL Task):

Use master...

I do something similar, to populate a reporting database. I run a dts package from the reporting server that first backs up the production database to a dump device (disk)...

     I set up some heavily accessed OLTP databases  and Data Warehouses on SANs (seperate ones), and here's one tip from my experience. I was running into very high Average...

the last paragraph of my reply got cut off...

I like this method because I can do some custom reporting for management /interested users. I prefer having one SQL Server Agent...

I have some pretty detailed DTS jobs that import data from our production financial system to a reporting database (as well as backup production, restore to a test server, do...

I wanted to do the same thing, but I didn;t want to use the DTS object model because I wanted to ensure that the DTS package would execute on the...

Hello,

     Not to pick nits, but Hot Swap means you can swap out drives with the power on (there's hot swap PCI, Memory, Power Supplies, Hard Drives, etc.) At least...

Here's how RAID5 and HotSpares work (fairly simplistic view).

Raid 5 is a n+1 configuration. Meaning if you have 4 18GB disks in a RAID 5 set, you have 3x18GB space...

Someone else on this site sent me this useful script when I asked a similar question. You can use this in a conditional statement without building a temp table. It...

Thanks for the tips. I can't really change the source tables/database - it's a shrinkwrapped product. Maybe the checksum approach will work out.

I guess I wasn't very clear. I'd like to sp to return several record sets. I could put the individual SQL statements into a t-sql set on a job, but...

I've used RAID5 for data files and it worked OK (you have to analyze your application needs first).

RAID 1+0 (10 whatever you want to call it), will always be...