Please don’t hijack the thread. Post your query in new thread.

Sorry, I missed that part. Please see the modified code below, it works on my system.

Declare @UserName nvarchar(100)

Declare @user-id Uniqueidentifier

set @UserName = 'yes'

SELECT @user-id = [UserId] FROM [aspnet_Users] WHERE [UserName]...

Please check for two free eBooks here… http://www.sqlservercentral.com/Books/

•Troubleshooting SQL Server: A Guide for the Accidental DBA: It will help you in DBA’s day-to-day jobs.

•How to become an Exceptional DBA: It...

Please check for two free eBooks here… http://www.sqlservercentral.com/Books/

•Troubleshooting SQL Server: A Guide for the Accidental DBA: It will help you in DBA’s day-to-day jobs.

•How to become an Exceptional DBA: It...

It might sound silly but did you run the job? What’s the execution status?

It was a nice decision on your part. In general, you should avoid row-by-row operations as much as possible.

Couple of points:

•Please verify if variable @user-id has any special character that SQL Server uses for different purpose.

•Declare a variable @sql and store the SQL command in it. It will...

Please don’t compare questions & answers row-by-row. If I understood the question correctly, you already have a table with correct answers. Create another table (temporary / actual) for user supplied...

You have a great mind and many could learn from you if you'd just drop the tough guy act. You'd probably sell more books, as well, and you wouldn't have...

Can’t you setup a quick test on local servers? Create a dummy login & try it.

Agree with Sean...

However it’s not advised but here is an example to join text & varchar columns. It doesn't throw the error you mentioned.

create table text_table

(

...

That’s why I said hot (exact) / warm (with some lag) standby server. Server that is lagging (intentionally) behind can help me in getting last night’s data.

I am certainly not...

It should be local server login and internally mapped to Linked Server Logins.

OR

OSQL -S abcServer -d abcDB -U RemoteSql...

Can you please post table DDLs for table1 & table3? I just want to crosscheck the data types of columns that are used in join conditions.

I assume you are getting...

Nope, only the remote server login mapping. It’s useless once you drop the Linked Server. You need to create it again when you re-create (if at all) the Linked Server.