September 15, 2012 at 2:31 pm
Comments posted to this topic are about the item Show all Objects used by Linked Server
September 17, 2012 at 8:57 am
Hello,
Just wanted to let you know that this script isn't working properly on a SQL 2008R2 server. I think you may upload an older version. Getting erros on this line "????????@HoldServ varchar(800),"
You should also add "drop table #holdinfo;" at the end of the code to clean up once completed.
Cool concept!
Thanks,
Rudy
September 17, 2012 at 10:46 am
Hello,
Got your script to execute. Looks like the spaces from the copy/paste from the website caused issues. Now I get the proc created and have created a link connection to a test server but no results from your code.
Thanks,
Rudy
September 17, 2012 at 11:15 am
Hello,
Not sure why no results other then the linked server is not called within a view, procedure, table, or function in the given database. Please do me a favor and run the code outside of the stored procedure, and make sure the temp tables are indeed getting populated with a name, if they are and no data is coming back, check to make sure the database you are running in does indeed use the linked server. sys.sysobjects is a database specific view and not server wide. Lastly, no reason to add the drop statements in as running in a stored procedure the tables are dropped for you upon completion.
September 18, 2012 at 9:01 am
Hello,
Looks like the code works outside the stored proc. It could be a SQL 2012 issue, not sure. As for dropping the temp table, I still think it good to drop it anyway but that my preferance 🙂
I'll play a bit more later next week.
Thanks,
Rudy
Rudy
May 9, 2016 at 1:28 pm
Thanks for the script.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply