CODE TSQL – UDF function list to table

CODE TSQL – Simple cursor

FIX – Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.

Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.

Reason: SQL Server 2000 supports multi-instances, the originating_server field contains the instance name in the format server\instance. Even for the default instance of the server, the actual server name is used instead of (local). After the Windows server is renamed, these jobs still reference the original server name and may not be updated or deleted by the process from the new server name. It’s a known problem with SQL2000 SP3.

Fix

If SQL name is not correct run.

If SQL name is correct run.

Reference:
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642

CODE TSQL – Cursor to select tables with static prefix and date created.

CODE TSQL – Auto aenerate script to delete deprecated fields in current database

Requirements: field with a dep_ prefix.

CODE – TSQL Query to find ByteSize of all the tables in database

CODE – TSQL Query to display foreign key relationships and name of the constraint for each table in database