Just as an fyi, everytime you're going to get ALL KINDS of recompiles on this.  You should put all of your CREATE TABLE (which is different then DECLARE @table TABLE)...

I have no idea if I have any clue what you are talking about.  Here's a stab in the dark though.

You want to have one database (Jokes) for example.

You have...

Jamie,

Why don't you check out the backup/restore scripts here and see what you think:

http://weblogs.sqlteam.com/tarad

errr, you do know that you're not going to be able to recreate the data from the Log Explorer, right??????  When items are written to a transaction log backups, they...

I went ahead and setup the following on my server at home:

Virtual Server 2005 with the SQL Server Express2005 and all the VS2005 betas.  If you install any of the...

Put this into a file called backup.sql for example.  In your batch file, call osql with the -i backup.sql syntax.  You'll need to run it in master with an account...

Just to clarify here a little.  Are you searching for a procedure with 'SHIPPING_TOTAL' in the name or in the text of the stored procedure?  Also, is you server case-sensitive? ...

Can she do anything in database B?  Have you ran sp_change_users_login 'Report' to see if the SID is correct?

1. Right-click on a database.

2.  Go to All Tasks.

3.  Choose Maintenance Plan. 

4.  Follow the instructions.    It will even let you schedule it.

You...

Usual questions....do you have:

1.  The latest service packs and updates for Office?

2.  The latest service packs and updates for Windows?

3.  Any other application taking up memory that could contend such...

?????  The example I gave does work.  Just run it.  I agree that dynamic SQL isn't the best way to do this.  It would be bettre to just create a...

Depending on how fast you want this to run, you might also consider bcp.  You can wrap this in DTS also.

In order to test snapshots as in SAN snapshots???  Or are you just talking about restoring and verifying off another copy of the database?  Or are you talking about testing...

I haven't had any problems either installing it.  We went through our standard change control process.  We research it, apply it to the development servers, test the applications for a...

Using Named Pipes depending on the configuration can be slower, which would increase problems caused by blocking.  Ultimately though, it's the bad code or design causing the blocking.