March 10, 2014 at 7:37 am
I need to
Deny insert,update,delete on object::schema_name.replicatedobjectname to Login, how to get the schema names of all th etables for performing this .
March 10, 2014 at 8:10 am
Something like this?
SELECT DISTINCT SCHEMA_NAME(schema_id) AS SchemaTable
FROM sys.tables WHERE is_replicated = 1
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 10, 2014 at 9:49 am
this is not the output lam looking , i have 170 articles with different schema names , i want the output with the tables names with schema .
ex: i have article T with schema as dbo
the output will be dbo.t
rest all the would be like this schema.article
March 10, 2014 at 10:19 am
Well, add the [name] column to the query?
SELECT QUOTENAME(SCHEMA_NAME(schema_id)) + '.' + QUOTENAME([name]) AS SchemaTable
FROM sys.tables
WHERE is_replicated = 1EDIT Removed the DISTINCT (not needed)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply