Generate Login Script(2008R2 And Older)
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,781 reads
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,781 reads
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2015-08-24 (first published: 2015-08-04)
2,663 reads
A script to help you cleanup Files/Folders & Sub-folders.
2015-08-20 (first published: 2015-07-30)
89 reads
In this article, I would like to demonstrate about Filestream and FileTable implementation in SQL Server 2012.
2015-08-19 (first published: 2015-07-24)
1,633 reads
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
1,155 reads
2015-08-10 (first published: 2015-07-16)
1,613 reads
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2015-08-06 (first published: 2015-07-07)
867 reads
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2015-08-05 (first published: 2015-07-08)
2,168 reads
2015-08-04 (first published: 2015-07-08)
732 reads
2015-08-03 (first published: 2015-07-12)
1,389 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