DBUser Roles Script
This script will be used to script out the users and their permissions at the database level. We can use this when we are replacing /overrighting the existing database.
2011-12-28 (first published: 2011-11-22)
1,839 reads
This script will be used to script out the users and their permissions at the database level. We can use this when we are replacing /overrighting the existing database.
2011-12-28 (first published: 2011-11-22)
1,839 reads
This script can be used to generate alter column length of any string data type column(s) in a database.
2011-12-27 (first published: 2011-11-22)
1,280 reads
This script can be used to return a csv column such emails in separate rows
2011-12-26 (first published: 2011-09-14)
1,573 reads
These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.
2011-12-23 (first published: 2008-06-08)
2,383 reads
These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.
2011-12-22 (first published: 2008-01-29)
3,554 reads
A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.
2011-12-21 (first published: 2008-04-30)
4,273 reads
This script will find foreign keys (on referencing table) that are not indexed in SQL Server 2005.
2011-12-20 (first published: 2007-08-10)
3,782 reads
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005
2011-12-19 (first published: 2008-06-03)
3,348 reads
2011-12-16 (first published: 2007-12-27)
4,134 reads
Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.
2011-12-15 (first published: 2007-10-11)
3,628 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