Yes, it will work as long as you can afford taking the original DB offline for a few moments.

quote:

---

Will detatch/attach keep the...

IF EXISTS( SELECT 1 FROM mira.dbo.UserBirthDay WHERE BirthdayToday = 1 )

BEGIN

-- put your emailing code here...

END

Also, if your current database is [mira], I suggest you remove [mira]....

Backup and restore is one option. Detach/attach is another one but it will disconnect your original database. If the DB is not huge, backup/restore will do it.

Sure, attach/detach a database is the quickest way of disconnecting it, copying underlying files and reconnecting (attaching) on another server. It is very useful especially for very large DB when...

A good way to move databases is to backup and restore. Of course, you do it one DB at a time.

To move jobs to another server, you need to generate...

I just wonder if using UDF is better than using a SP on the linked server. The SP would return a rowset, of course, that would be inserted into a...

Allen, you are right. It works that way. Thank you.

So you have a column that indicates date, right? Do you need to see only last week's data or all three years data grouped by week?

In the first case, just...

Check in BOL for

SET LOCK_TIMEOUT

Sounds unusual but run

SELECT TOP 12532 * FROM table_name and look at the last row.

By the way, if you have a clustered index on that table, rows are physically...

I would suggest to execute sp_helptext on sp_helpdb to get the source code for sp_helpdb. Then look for the part of the code that is generating the second result set...

Here is what you need to do...

DECLARE @sql VARCHAR( 8000 )

SELECT @sql = 'INSERT ' + @loadname +

' SELECT * FROM ' + @holdname +

' WHERE release = 1'

EXECUTE(...

Brian, thanks you forgot the foreign keys.

I am sure there is a way to do it through the system catalog if I allow updates to the system tables. Of course,...

Well, it's a funny link that suggests to use Enterprise Manager. What if I need to do it for more then 100 client databases where each one has 19 tables...

Well, I could just add another column to that table , copy data from the IDENTITY column into it, drop the DIENTITY column and recreate it, then copy data back...