SSPI error and Incorrect timing.
TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...
2013-03-28
1,687 reads
TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...
2013-03-28
1,687 reads
One method my company deploys our software is in a dedicated hosted environment. In this situation, we partner with a...
2013-03-28
1,199 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-28
1,989 reads
It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a...
2013-04-05 (first published: 2013-03-28)
3,929 reads
My first article in SQL Server Pro magazine has been published. It is entitled “SQL Server 2012 Business Intelligence Enhancements”...
2013-03-28
1,598 reads
There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...
2013-04-05 (first published: 2013-03-28)
3,356 reads
Learning Tree are offering their 3 day SQL Server High Availability course this April in London. Running between 17th and...
2013-03-28
1,483 reads
New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and...
2013-03-28
1,698 reads
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s...
2013-03-27
3,300 reads
Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment...
2013-03-27
1,654 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