Snipplr

(SQL) Search object in all databases - pollusb

Mon, 31 Aug 2009 16:33:43 UTC

Place you object name here must be replaced with your object name ;)

(SQL) RESTORE DATABASE from a list of files - pollusb

Thu, 16 Apr 2009 22:30:59 UTC

Use a file list to generate a RESTORE script. You may want to review the WITH option. This script is for advanced user only. Works only with 1 file per database backup.

(SQL) Last Backup Date for All databases - pollusb

Thu, 16 Apr 2009 00:09:03 UTC

In a migration scenario, you may need to take a backup and a differential later to split the transfer over time. But to make it work, there shouldn't be any other full backup in between. This will help you check the last full backup date. Of course, you could use it for a lot of other reason.

(SQL) Extract logins default db - pollusb

Thu, 26 Mar 2009 13:26:18 UTC

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

(SQL) sp_ColDefinition or writing upsert SP in a snap - pollusb

Wed, 25 Mar 2009 22:17:48 UTC

sp_ColDefinition will use the metadata tables to create a table result that looks like this : DECLARE --------------------- @title_id varchar(6), @title varchar(80), @type char(12), @pub_id char(4), @price money, @advance money, @royalty int, @ytd_sales int, @notes varchar(200), @pubdate datetime(8),

(SQL) Linked Servers Summary - pollusb

Tue, 24 Mar 2009 11:56:32 UTC

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 - pollusb

Fri, 20 Mar 2009 18:09:59 UTC

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 - pollusb

Fri, 20 Mar 2009 18:05:00 UTC

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 - pollusb

Thu, 12 Mar 2009 17:30:34 UTC

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 - pollusb

Tue, 10 Mar 2009 20:46:52 UTC

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.

(SQL) Detach and Attach all - pollusb

Tue, 10 Mar 2009 19:09:58 UTC

I wrote that while working at CGI on OcÃ© project in 2009-03. This script will help you migrate DB from one server to another. You have to use the source server to generate the script for the destination server.