http://snipplr.com/language/sql/tags/migration Recent snippets posted on Snipplr.com en-us Fri, 24 May 2013 00:12:14 GMT http://snipplr.com/view/13485/extract-logins-default-db/ Extract logins default db settings from one server to export to another

]]> Thu, 26 Mar 2009 13:26:18 GMT http://snipplr.com/view/13485/extract-logins-default-db/ http://snipplr.com/view/13404/linked-servers-summary/ 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.

]]> Tue, 24 Mar 2009 11:56:32 GMT http://snipplr.com/view/13404/linked-servers-summary/ http://snipplr.com/view/13329/unable-to-delete-or-disable-sql-server-job-due-to-error-regarding-msx-server/ 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

]]> Fri, 20 Mar 2009 18:09:59 GMT http://snipplr.com/view/13329/unable-to-delete-or-disable-sql-server-job-due-to-error-regarding-msx-server/