Snipplr

(SQL) Delete All Foreign Keys - marcocs

Mon, 26 Oct 2009 05:31:51 GMT

Delete All Foreign Keys in a database; (make sure you USE keyword)

(SQL) Find Keywords in SQL Server Stored Procs and Functions - marcocs

Wed, 23 Sep 2009 17:51:37 GMT

Find Keywords in SQL Server Stored Procs and Functions Written By: Tim Ford

(SQL) Last statement run for a specific SQL Server session - marcocs

Wed, 23 Sep 2009 17:49:45 GMT

Identify last statement run for a specific SQL Server session Written By: Tim Ford -- 7/22/2009

(SQL) Who block Who? - marcocs

Sun, 20 Sep 2009 18:12:17 GMT

"LEFT JOIN sys.dm_exec_sessions SB" only for test... It is not necesary becouse in a real block condition "blocking_session_id" is not null. so, when you have tested it just replace Left with INNER JOIN sys.dm_exec_sess... Good block detection to all!

(SQL) All Columns in a Table - marcocs

Wed, 16 Sep 2009 10:44:50 GMT

Simple but...

(SQL) Foreign Key with Action - marcocs

Wed, 19 Aug 2009 04:51:43 GMT

Foreign Key with actions on delete or update.

(SQL) Buscar tablas por tipo de columnas - marcocs

Fri, 31 Jul 2009 03:56:11 GMT

Buscar tablas por tipo de columnas; Note:AND OBJECT_NAME(object_id) NOT LIKE 'sy%': cuidado si tienes tablas que empiezan con "sy%"

(SQL) Buscar tablas por nombre de columnas - marcocs

Fri, 31 Jul 2009 03:53:37 GMT

Buscar tablas por nombre de columnas;

(SQL) Reboot SQL Server - mafro

Fri, 17 Apr 2009 05:43:40 GMT

This snippet enables a reboot of an SQL Server when the connecting user is running with the 'sysadmin' server role.

(SQL) Extract logins default db - pollusb

Thu, 26 Mar 2009 13:26:18 GMT

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

(SQL) Linked Servers Summary - pollusb

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

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

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

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

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.