Select the last error in the job selected
The job will send an HTML email with the latest error at specific job.
2012-03-15 (first published: 2012-03-05)
954 reads
The job will send an HTML email with the latest error at specific job.
2012-03-15 (first published: 2012-03-05)
954 reads
Stored procedure to update SSRS Subscription owners to avoid email errors.
2012-03-13 (first published: 2012-02-28)
1,498 reads
Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.
2012-03-10
2,907 reads
Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.
2012-03-09 (first published: 2008-01-07)
4,271 reads
You can use this script to check if any procs will break under compatibility level 90.
2012-03-08 (first published: 2008-01-29)
4,401 reads
Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).
2012-03-07 (first published: 2008-01-14)
3,955 reads
Sending Job Failed Information Through E-Mail Using T-SQL.
2012-03-06 (first published: 2012-02-13)
2,337 reads
Two simple scripts to check table and database sizes. The scripts use temporary tables and the sp_msforeachdb/sp_msforeachtable stored procedures to present the output neatly.
2012-03-05 (first published: 2012-02-19)
2,723 reads
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-02 (first published: 2012-02-21)
1,160 reads
TSQL code that generates numbers (tally table) from 1 to N without using any tables
2012-03-01 (first published: 2012-02-21)
1,842 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers