I'm done with this!

What I did is removed the ID from the insert statement and it automatically generated the ID.

It inserts without problem now!

Thanks for all who participated.

Stewart "Arturius" Campbell (4/11/2012)

---

Within SQL Server Management Studio, connect to the local server.

Then:

> Expand the "Server Objects" folder

>...

Stewart "Arturius" Campbell (4/11/2012)

---

This means that the Server Options page of the linked server (on your local server) needs to be changed;

the RPC and RPC Out options must be set...

Stewart "Arturius" Campbell (4/11/2012)

---

Provided the user allocated for the remote server has the necessary priviliges, consider effecting the following on your local server:

EXEC ('SET IDENTITY_INSERT db1.dbo.TWMS_Permission ON') AT [RemoteServer]

INSERT INTO...

I can't log on to the remoteserver. It was only the name that has been provided. I can only log to my local server. So what should I do now?

drew.allen (3/8/2012)

---

Try using a CROSS APPLY instead of the EXISTS.

UPDATE t1

SET t1.col1 = t2.col1, t1.col2 = t2.col2, t1.col3 = t2.col3, t1.col4 = t2.col4, ........

FROM t1

INNER JOIN t2

ON t2.ID = t1.ID

CROSS...

---

There is no relationship between the t1 in the update part of your query and the t1 in the exists part. The same thing is true for the both t2's....

Thanks for those who replied to this post.

I have solved the problems using these dynamic scripts:

SET @SQLString =

N'SELECT @ColumnName1 = STUFF((SELECT '', '' + C.name

...

Ok. This answers one of the errors. I'll note that. Thanks, Grasshopper!

manukumar (3/4/2012)

---

You can not truncate the table if any column is referred by any other table like primary and...

Yeah, I got it now.

This link helped!

http://blog.sqlauthority.com/2007/12/07/sql-server-fix-error-3702-cannot-drop-database-because-it-is-currently-in-use/

Thanks again!

On my Stored procedure, I put

USE [master]

on top of the content.

and yet, i'm getting this error:

Msg 3702, Level 16, State 4, Line 1

Cannot drop database "TA_839" because it is currently...

How can I do verification?

I'm having problem now.

There error saying:

Msg 3702, Level 16, State 4, Line 1

Cannot drop database "TA_839" because it is currently in use.

Also, I'm not sure...

Wow! It works!

Thanks to Koen Verbeeck!!!