We run daily index maint job.

here is the link which used to set up our index Maint job: http://ola.hallengren.com/

Any help how to increase the scan density ?

hey I try to execute (Reverse-Engineer Database Permissions (2005 up)) http://www.sqlservercentral.com/scripts/Permissions/76450/

I am getting error.

Msg 102, Level 15, State 1, Procedure usp_get_object_permissions, Line 44

Incorrect syntax near '?'.

Msg 102,...

sp_help_revlogin : List outs all the logins from the server,

I dont want all the logins.

I just need for a list all the logins in a database:

which include...

It did'nt help....

I need help in scripting out permissions for a database.

Please don't say sp_help_revlogin: It gives list out all the logins on a server.

Thanks for your replay,

If I am doing refresh from PROD to DEV.

I need take a backup script out permissions for a database before restoring in DEV.

and restore the permissions...

How to use the script to run. Can we schedule with an agent job.

Thanks for your replay,

Any Help ...!

Thanks !

Thanks Michael!

Can I get a command of (ActiveX , Command shell, or Powershell)

example my file name are: DBname_DBuserlist_20121009.txt

Location Z:\Permissions\

Using SA account.

All my .bak backup cleanup history works fine, cleanups after 48Hrs.

I doesn't work for my txt file to cleanup. These txt file are created by job in...

Yes looks the same

That does not work,

I am looking for Stored Proc, When I pass the parameter as the login name.

It should create login script, Grant permission scripts & exec sp_addrolemember...

How are the missing indexes created on the table?

on our Prod server, we see a quite few number of missing indexes created.

My findings are:

1)Job on DBSTU server: Agent history clean up: distribution is failing.

From the Job error I figured out was Table [dbo].[MSmerge_history] on distribution was missing.

This is causing issue? I...

Pub :2008r2

Dist and Sub : 2012

seems now every thing is working.

Cannot add server to Replication monitor,

It show red cross mark? what does this mean?

I have run sp_removedbreplication...