SQL Server Downloads |
|
| file | | user | | section | | date | | size |
|
|
| Change Execute Permissions | | akaplan | | Scripting, SQL Server, Patch Management | | 1/9/2009 | | 1.8 kb |
|
| This will set apply the workaround in MS Advisory 961040 by running "use master; grant execute on sp_replwritetovarbin to public" remotely. Integrated authentication must be enabled for this to work. |
|
|
|
| Get Last SQL Backup | | akaplan | | Scripting, SQL Server | | 12/3/2007 | | 3.5 kb |
|
| Script connects to SQL server, gets list of databases, last successful backup and count of backup files. |
|
|
|
| Change SQL SA password | | akaplan | | Scripting, SQL Server, Security | | 11/17/2006 | | 4.1 kb |
|
| Blank SA passwords on SQL databases are a plague. This script lets you add a SA password locally or remotely if you have integrated security enabled and are an admin. I use SQLRecon to look for open SA passwords. You can find it at http://www.specialopssecurity.com/labs/sqlrecon/.
|
|
|
|
| Windows Server 2003 SP1 SMS 2003 SP2 with Advanced Security and Remote SQL 2005 | | schan974 | | SMS 2003, Windows, SQL Server | | 7/26/2006 | | 29.5 kb |
|
| How to configure SMS 2003 SP2 with Advanced Security to run on Windows Server 2003 SP1 and Remote SQL Server |
|
|
|
| Full Code Repository | | rcrumbaker | | SMS 2.x, SMS 2003, Scripting, SMS Installer, Miscellaneous, Windows, Networking, SQL Server | | 6/1/2005 | | 3.2 mb |
|
| Contains all the Code Packs and Application Packs. |
|
|
|
| Convert Value To Myanmar Char | | m007 | | SQL Server | | 5/10/2005 | | 14.4 kb |
|
| This Component is base SQL Server and it convert to Number Value To Myanmar Language. |
|
|
|
| Get SQL Version (revised) | | akaplan | | Scripting, SQL Server | | 12/28/2004 | | 1 kb |
|
| Gets the SQL version of remote SQL Server, using @@Version which is supported on more versions. Added: Enables/Starts remote service if necessary, and restores sevice state when done. Written to help with MS True Up count. |
|
|
|
| Get SQL Version | | akaplan | | Scripting, SQL Server, Patch Management | | 12/13/2004 | | 1.1 kb |
|
| Written when I got tired of trying to figure out whether the instances of MSSQLSERVER were running MSDE or SQL, this script uses SERVERPROPERTY to get edition, version, and SP from remote server. Connection string uses integrated authentication. |
|
|
|
| OpalisRobot | | ljohns178 | | MOM, NetIQ, Scripting, Windows, Networking, SQL Server | | 1/28/2004 | | 452.7 kb |
|
| OpalisRobot is an object oriented, automation solution. OpalisRobot automates data center operations by integrating independently designed management applications, with user expertise and data center procedures, reducing operational costs and increasing availability and performance of computing environments. |
|
|
|
| IBM Conversion | | rthrelkeld | | SQL Server | | 4/6/2003 | | 1.1 kb |
|
| IBM Serial number data does not roll up correctly into the Computer_System_DATA table in SQL and needs to be reformatted into it's more common names. According to IBM, models start with 4 common digits and can be grouped based on them. |
|
|
