Tag Info

New answers tagged

2

Here is sample code I used to get this working, hope this helps somebody! Linked Server set from 2000 to 2012. USE master GO -- Drop Existing LinkedServer [CARME]: EXEC sp_dropserver @server=N'CARME', @droplogins='droplogins' GO -- Re-create LinkedServer [CARME] by using the ODBC connection: EXEC sp_addlinkedserver @server = N'CARME', ...


1

Ugh, 2000. Assuming all objects are owned by dbo, you can generate a script, e.g.: SELECT N'GRANT INSERT, UPDATE, DELETE, SELECT ON dbo.' + QUOTENAME(name) + N' TO [user];' FROM sysobjects WHERE type IN (N'U', N'V'); SELECT N'GRANT EXECUTE ON dbo.' + QUOTENAME(name) + N' TO [user];' FROM sysobjects WHERE type = N'P'; Now you can copy and paste the ...



Top 50 recent answers are included