How to write a script on SQL Server Standards

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

How to write a script on SQL Server Standards

Author

Topic

reddy_vam
Starting Member

43 Posts

Posted - 2008-11-26 : 10:19:36

Hi Folks,

i want to write a script to genearte complete report on current sql server standards on a particular server

my output should be

Current authentication mode
list out if there are any sample databases existsed
No of error logs existed
Current setting of SQl Mail (enable or disable)
Database Owners Permissions
type of backup using for all databases
Distribution database locations.

Thanks in advance,
Vamshi

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-26 : 10:50:49

1) See http://weblogs.sqlteam.com/peterl/archive/2008/06/19/How-to-get-authentication-mode-in-SQL-Server.aspx
2) SELECT * FROM sys.databases where name in ('northwind', 'adventureworks', 'pubs')
3) EXEC master..sp_enumerrorlogs
4) EXEC sp_configure 'SQL Mail XPs'

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources