i googled this script.

yes , can you please modify the script by adding this and help .

im not expert in scripting

I need to display the output with the additional column "login type as windows \sql login "in the output after executing the given query .

can any one...

iam expert in changing the code pls send the queries if any as per my requirement .

i googled and found some scripts, tired but the output is in different format . i need the same output format for my scenario

Thanks for the queries , really needful

Thanks for the reply is this query is defined to drop only one article , if yes what is the ysntax to drop multiple articles on publisher ?

Thanks for repling , actually iam not aware how to trouble shoot this issue ?

can you send any query to do

specified reconfigure

default is 600 secs if i change to 0 is it will impact the other applications?

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:...

@mic

i executed the script which u provided but i didnot get any output when i removed comments under

-- Remove the comments below if you want to execute this!

...

sorry .. its a CS

got the error while executing

CREATE TABLE #DBROLES

(

DBName SYSNAME NOT NULL ,

UserName SYSNAME NOT...