Viewing 3 posts - 1 through 3 (of 3 total)
Providing a username and password in the linked server settings is what solved this problem for me. The user must of course have permissions to read active directory.
December 23, 2013 at 4:34 am
#1675537
Thank you - problem solved.
(Needed also brackets for DB name: '.....FROM ['+@vcDatabaseName+'].dbo.sysfiles')
May 7, 2013 at 10:06 am
#1613058
Nice script -thanks for sharing.
I get multple errors when I run it though:
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'Service_1d756ce176df40ff88162ccaa'.
Incorrect...
May 7, 2013 at 5:45 am
#1612932