id and oldid is one-to-one? or many-to-one?

Following works fine with me in scheduled restore.

ALTER DATABASE DatabseName

SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

--DO restore

ALTER DATABASE DatabseName

SET MULTI_USER

GO

Thanks Eugene Elutin, I didn't think it is that simple

It has many...

How about deleting records from original table and inserting to another table using OUTPUT..DELETED.. INTO..

On error rollback the transaction. This approach will make sure you are deleting in one table...

Sorry I miunderstood the question, removing my code

Use intermediate table to hold both the values... Something like this... You have to lock the table #Test in this approach

Create table #Test (pKeyCol int identity(1,1), Description varchar(10))

insert into #Test...

Grant Fritchey (6/13/2012)

---

Daxesh Patel (6/13/2012)

---

if table has a large size data, I think SELECT * INTO should be avoided due to its limitations.

I would create New table ahead of time...

anthony.green (6/13/2012)

---

Daxesh Patel (6/13/2012)

---

if table has a large size data, I think SELECT * INTO should be avoided due to its limitations.

I would create New table ahead of time with...

if table has a large size data, I think SELECT * INTO should be avoided due to its limitations.

I would create New table ahead of time with partitions (each partition...

In following, -2 will give you previous Saturday, you can manipulate this number to get other days

select b,dateadd(day,Datediff(Week,0,GETDATE()) * 7,-2+((b-1)*7))

from (values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13)) a(b)

How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server

I think you could use table that has ThreadID as PK to get top 5 thread and then retrive details from Forum_Posts table.

In your code example you can do something...

select DB_Name(database_id) DataBaseName,physical_name,size/128 SizeInMB,* from sys.master_files

select Sum(size)/128 SizeInMB from sys.master_files

This is from BOL

I think you need to enable RPC for Linked server B when....

you have created...