SQL Server: List Explicit Permission on Database for Login and Database Role
As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...
2012-08-07
5,510 reads
As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...
2012-08-07
5,510 reads
This month Kevin Kline will be presenting "End to End Troubleshooting" at the Boulder, Colorado Springs, and Denver SQL Meetings
Summary:...
2012-08-07
652 reads
Here is the August 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-08-07
1,053 reads
During the January board meeting we were told that attendance at the 2011 Summit exceeded expectations and as a result...
2012-08-07
637 reads
When I ran for the PASS Board of Directors last year I committed to providing a monthly update on PASS...
2012-08-07
971 reads
We have all been there; you need to take a look at the data inside a file. Sure you can...
2012-08-07
1,802 reads
I just finished this book. Literally. Sitting on an airplane in route from Orlando to Charlotte NC. I got up...
2012-08-07
1,031 reads
Many times I have seen this question coming from users - Can I still buy per socket licenses for installing SQL2008...
2012-08-07
756 reads
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,297 reads
Writing - be it a technical language like T-SQL, C#, PowerShell, etc. or blogging - is like exercise. When you do it...
2012-08-06
1,537 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