Snipplr - pollusb

(SQL) Extract logins default db

Thu, 26 Mar 2009 13:26:18 GMT

Extract logins default db settings from one server to export to another

(SQL) Linked Servers Summary

Tue, 24 Mar 2009 11:56:32 GMT

This piece of code is really useful to manage the Linked Servers. It will tell you if a linked server is no longer valid. That is pointing to an invalid DNS entry or an address that doesn't ping.

(SQL) Unable to delete or disable SQL Server job due to error regarding MSX server

Fri, 20 Mar 2009 18:09:59 GMT

This is a simplified version to resolve the error "Unable to delete or disable SQL Server job due to error regarding MSX server" when migrating a server

(SQL) Deactivate jobs on SQL Server

Fri, 20 Mar 2009 18:05:00 GMT

Let's say you need to deactivate jobs, do something, then reactivate jobs. You can use this to generate the code for both by changing "@enabled = 0" with 1

(SQL) Determine Free Disk Space in SQL Server

Thu, 12 Mar 2009 17:30:34 GMT

This is not my code but I really like the fact that it's not using a COM object to do it's task such as the one I've been using for years.

(SQL) Connect SQL Server to a Windows Shared Folder

Tue, 10 Mar 2009 20:46:52 GMT

This is how you can connect SQL Server to a Share folder for your backups. After running this, you will see the letter T: in the GUI. Each line must be run seperatly.