Ahh, thank you 🙂

I've also found that this works: EXEC(‘TRUNCATE TABLE [Test_DB].dbo.thisTable’) AT [Link-Server]

thanks for the replies! I'm trying to create the linked server as part of a stored procedure, that 1) creates the linked server 2) updates a table and then...

Thanks again. I added the SPN's, but when I try to log on, I get the "Cannot generate SSPI context" error on my SQL client. On the server's...

I created a new domain account and added it to all the SQL local groups on the server (the ones that get created when installing SQL). Then I made...

yes, when I use a regular SQL login on the remote server as the security context, it works.

But correct me if I'm wrong, that is an "always on" connection that...

Thanks. I've tried that as well, and it didn't work either. If I put in my login or use "domain\Administrator" (which is a valid login on both servers)...

Thanks again, I really appreciate the help.

The linked server is on Server A (SQL2005):

Server Type: Other Data Source

Name: Linkedserver

Provider: SQL Native Client

Data Source: Server\SQL2008

Provider string: Integrated...

when trying to copy and paste this script into my SQL manager studio, it gives me a ton of "Incorrect syntax near '?'." errors due to the characters spaces in...

Ok, thanks. I'm pretty sure they use ad-hoc queries. How would I modify it? Some jobs just use SQL queries, others I see have steps that use...

that works awesome! Thanks so much! Will that find it in a scheduled job as well?

Sorry, not sure I explained it well. In my SQL 2005 instance, there are queries and stored procedures within 2 or 3 databases. Inside these queries for example,...

trying to save this as a stored procedure in SQL2005, but am getting an error: Cannot assign a default value to a local variable.

Any help is greatly appreciated, thanks!

this script is really great, thanks! Is there any way to add the user and/or host machine name that is running the query? (so I know who to...

Awesome! Thanks!