SSMS is what I do not want to give.

I need a simple tool like ARS for AD for USer creation etc...

Actually that is a good question. But we have a standard template for user permmissions request which they can follow wasily. We just need a tool which is easy to...

http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/7d46a024-7ed5-4c9b-b091-3640dc04f5a1/

The DEFAULT_SCHEMA clause cannot be used with a Windows group or with principals mapped to certificates or asymmetric keys.

Using GUI.

And I do not want the users to specify like dbo.

For windows logins it is working but for a windows group it does not.

unable to assign default schma as dbo in sql server for a sql server group alongside a database name.

jobs, ssis exists in msdb.

I dont thin your solution will work.

I am looking for for trasferring all metadata to my DR server everyday which includes linked servers, logins, system roles, system databases access etc...sql...

check policy is ON for my SQL Server accoutmscheck policy is ON for my SQL Server accounts and my local windows policy says 90 Days expire for my accounts.

If I...

Many Thanks for your reply.

I saw an article :-

http://sqlserver-qa.net/blogs/perftune/archive/2008/04/30/4133.aspx

Is it possible to use my windows AD policy for my SQL server accounts like "sa"?

And how can I get...

Thanks for your reply.

Sorry I am bit confused here.

I am not looking for domain accounts which are my logins in SQL Server.

I am looking for changing the password for sa...

I created a password verify fuction in orale with the following considerations:-

•Password should not be same as the username

•Length of the password should be at least 8

•Password...

HI, I saw this great procedure.

My requirement is similar but I have around 50 instances.

Can we change this procedure to get a instance name as an argument and not compliling...