Using the PowerShell SQL Provider with SQL Authentication
Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL...
2017-01-12
2,087 reads
Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL...
2017-01-12
2,087 reads
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and the messages on the output window show something like [16:08:11]...
2017-01-11
38 reads
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and...
2017-01-11
220 reads
I posted this, but here it is again. A a shot from our engineer, behind the scenes of my live...
2017-01-11
552 reads
Open any book or article about database development and administration, and I can all but guarantee that you will find a section for database documentation that describes its importance,...
2017-01-11
49 reads
Bit of fun this week with something that a colleague of mine noticed when playing around with SQL Server on...
2017-01-11
1,031 reads
This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger”...
2017-01-11
831 reads
DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...
2017-01-11
401 reads
We have all made mistakes in our careers, I thought I’d share one of mine as a quick tip to...
2017-01-10
584 reads
AdvertisementsThis month’s T-SQL Tuesday topic is “SQL Server Bugs & Enhancement Requests” and hosted by my favorite and inspirational Brent Ozar.
Here...
2017-01-10
592 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