<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts by Rudy Panigas
SQLServerCentral.com profile
Items 1 to 10 of 10
Calculate the values for MAX Memory for SQL Server
Use this script to calculate MAX memory setting on a dedicated SQL server.
Read more...
By
Rudy Panigas
2012/01/27
|
Source:
SQLServerCentral.com
|
Category:
max memory setting
Rating:
|
Discuss
|
Briefcase
|
1,644 reads
Query Active Directory to Display Login Information
Query Active Directory to get information on user logins.
Read more...
By
Rudy Panigas
2011/05/19
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
2,616 reads
Show SQL authentication login information
View login information for all accounts that use SQL authentication.
Read more...
By
Rudy Panigas
2011/05/12
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
2,229 reads
SQL Server Port Number Identifier
Find SQL server port number for SQL 2000, 2005, 2008 and 2008 R2
Read more...
By
Rudy Panigas
2011/01/21
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,304 reads
SQL Server Service Check Utility
Script will display current status of SQL server services and even show if not installed. Works on SQL 2005,2008 2008R2. Both 32 and 64 bit servers.
Read more...
By
Rudy Panigas
2010/11/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,547 reads
T-SQL generator for sp_configure
The purpose of this code is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from.
Read more...
By
Rudy Panigas
2010/10/14
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,135 reads
Collect SQL Server/Process Information - Quickly
Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.
Read more...
By
Rudy Panigas
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
monitoring
Rating:
|
Discuss
|
Briefcase
|
4,747 reads
Cluster Information
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
Read more...
By
Rudy Panigas
2009/05/08
|
Source:
SQLServerCentral.com
|
Category:
clustering
Rating:
|
Discuss
|
Briefcase
|
1,054 reads
Remove SQL Logins from All Databases and SQL Server
Locate and remove/delete user logins from all databases and even SQL server.
Read more...
By
Rudy Panigas
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
3,300 reads
Execution of Code on Multiple Servers Remotely
Read more...
By
Rudy Panigas
2006/12/28
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
642 reads
Items 1 to 10 of 10
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
