Keep an eye on those Audit files!
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server...
2015-10-13
513 reads
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server...
2015-10-13
513 reads
In the previous blogs we saw the use of certificates to encapsulate symmetric keys. How it benefits the user by...
2015-10-13
577 reads
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
446 reads
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
753 reads
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
618 reads
This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...
2015-10-12
527 reads
SQL Saturday #442 in Orlando, FL has come and gone but what a turn out! The event was excellent, we...
2015-10-12
479 reads
I have demonstrated how to backup a deployed session to a script previously. In this article I demonstrate how to create Simplified Session Backups.
Related Posts:
PowerShell to Backup XE Session...
2015-10-12
13 reads
PowerShell exposes scads of information and provides the professional with a formidable tool for the tool-belt. Over the past several...
2015-10-12
490 reads
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
44 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
Comments posted to this topic are about the item Switching Schema II
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