Hey Paul,

This was actually a database on 2000 later upgraded to k5. I do not have any remembarance when it ran successfully last time without errors. Now, we are trying...

Msg 8992, Level 16, State 1, Line 1

Check Catalog Msg 3855, State 1: Attribute (referenced_object_id=1874157772,key_index_id=2) exists without a row (object_id=1938158000) in sys.foreign_keys.

Msg 8992, Level 16, State 1, Line 1

Check Catalog...

Hi Gail,

I ran the integrity check with the DBCC checkdb with noinfomsgs,allerrormessage and the error is the same as i have mentioned above. Actually we already know the...

Hi Gail,

Thanks for replying. As it is in the production, I will run it sometime later this week and will post the result.

Hey guys,

Thanks for the reply. Actually I got the answer after I started the thread.What I did was queried the server_principal and database_principal and got what I wanted. If you...

Exactly TVR.. Its a double hop issue.. Thanks for the reply..

Hi Deepthi

I need to list all the granular level permission of a user defined database roles. What do I do?

We have like different enviroments with similar kind of replication setup. So, I kinda wanted to have a script such that the record count of the article of certain publication...

There will be no generate script option if u right click on the server. I guess you mean to say the database but even if you use that wizard it...

This is the requirement coz we need to script out all the security of a server and place it in a folder for our project. Can somebody reply me how...

Yes Greg I m sorry I was in the wrong database. Thanks anyways.

Greg,

I queried the sys.database_principals but it did not retrieve the application roles. It only displayed the database roles and some other schemas..

Greg,

If a user is assigned an application role, Can we script that too?

Thanks

There is no straight way thru SSMS. I think you gotta have a custom script. I will do a research and reply you back if i get it.

Did u tried to generate scripts with the wizard making the options for object level permission to true?