Objects dependency check up in SSMS
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s)...
2016-05-20
17 reads
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s)...
2016-05-20
17 reads
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s)...
2016-05-20
17 reads
Looking forward to the triumphant return of SQLSaturday Pensacola on June 4, thrilled that this start-of-summer tradition is back! This has been...
2016-05-20
372 reads
Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business,...
2016-05-31 (first published: 2016-05-20)
1,972 reads
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many...
2016-05-20
209 reads
Nature of the Issue Faced :- Say you have 3 columns in a tablix/table on the report. There are 3 textboxes...
2016-05-30 (first published: 2016-05-20)
1,148 reads
I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this...
2016-05-19
502 reads
Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance...
2016-05-27 (first published: 2016-05-19)
1,555 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-05-27 (first published: 2016-05-19)
2,225 reads
Last month I wrote a post titled Broken Left Join which covered an easy to make mistake that I see...
2016-05-26 (first published: 2016-05-18)
1,815 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