Denali — Day 11: SSMS enhancement
Denali — Day 11: SSMS enhancement
SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA...
2012-05-11
675 reads
Denali — Day 11: SSMS enhancement
SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA...
2012-05-11
675 reads
Hi,
one of SQL Treeo users developed clever workaround for SQL Treeo SSMS Add-in to be more compatible with RedGate SQL...
2012-05-11
1,203 reads
I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...
2012-05-10
3,976 reads
Change Tracking (CT) and Change Data Capture (CDC) were both added to SQL Server in 2008. At first it seems...
2012-05-10
49,426 reads
Best. Luncheon. EVAR.
I just finished up moderating this year’s Women in Technology panel here at SQLRally, and it was fantastic. ...
2012-05-10
711 reads
I will be presenting two sessions at the Rocky Mountain Tech Trifecta in Denver on May 19, 2012. This is...
2012-05-10
854 reads
Hello Dear Reader! I'm coming to you live from the wonderful SQL Rally in Dallas Texas. I have two sessions...
2012-05-10
508 reads
Ran across this recently, YourLogicalFallacyIs.com is a site that lists all the ways you can apply logic badly, and they’ve...
2012-05-10
877 reads
If you don’t change the version number of your .NET project output every time you create a setup package, you...
2012-05-10
1,754 reads
Had a nice lunch at On The Border at Orlando International before my flight, used that time to finish some...
2012-05-10
633 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...
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
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
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