Find failed SQL Agent jobs using Transact-SQL script
Today, I’m sharing the following T-SQL script which you can use to find which SQL Server Agent Jobs failed yesterday....
2012-08-15
2,318 reads
Today, I’m sharing the following T-SQL script which you can use to find which SQL Server Agent Jobs failed yesterday....
2012-08-15
2,318 reads
I have been using VMware vSphere client for a while now and the person who inspired me to use this...
2012-08-15
1,448 reads
After reading about the Amazon/Apple attack this morning, I grabbed a second cup of coffee and went in search of...
2012-08-15
717 reads
I have been told by hundreds of DBAs that I have the best DBA job in the world as Director...
2012-08-15
1,148 reads
I’ve been out of town and off the grid – nothing like 10 days of family camping and roadtripping to unwind!...
2012-08-15
875 reads
On July 16, 2012, Office 2013 Preview was released to the public (download). Excel 2013 now includes a lot of the...
2012-08-15
1,865 reads
When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on. Before I...
2012-08-15
517 reads
If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September...
2012-08-15
1,354 reads
I read an excellent article by Camille Fournier about the importance of recognizing that being right is not the only...
2012-08-15
854 reads
The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local...
2012-08-15
1,108 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