SQL Server 2012 Express installation failed issue
I got an strange error when installing SQL Server 2012 Express
Environment:Window Server 2008 R2 Enterprise + SP1Microsoft Visual Studio 2012 installed.Net...
2013-08-07
1,953 reads
I got an strange error when installing SQL Server 2012 Express
Environment:Window Server 2008 R2 Enterprise + SP1Microsoft Visual Studio 2012 installed.Net...
2013-08-07
1,953 reads
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-12 (first published: 2013-08-07)
13,411 reads
Hello Friends,
It’s being a many days I haven’t written anything. But there was lot of stuff I was thinking to...
2013-08-07
1,570 reads
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
34 reads
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
59 reads
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child...
2013-08-13 (first published: 2013-08-07)
4,725 reads
The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those...
2013-08-07
676 reads
Cleaning/deleting the old backup files is equally important as taking the backups. Doing so we can (i) Avoid overhead cost for...
2013-08-07
1,011 reads
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-07
1,252 reads
This post is to find the database file usage details of all databases of an instance. The query runs on...
2013-08-06
1,929 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,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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