Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,428 reads
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,428 reads
2011-10-06 (first published: 2007-11-14)
1,962 reads
The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.
2011-10-05 (first published: 2011-09-09)
7,761 reads
The script shows one of ways generating number sequence - this one uses CTE.
2011-10-04 (first published: 2008-02-06)
2,017 reads
2011-10-03 (first published: 2008-03-27)
7,280 reads
Copy Multiple objects from One Schema to Another Schema
2011-09-30 (first published: 2011-09-07)
1,586 reads
A function to replace tab characters with the correct number of spaces to align the text as originally intended.
2011-09-29 (first published: 2007-10-11)
2,261 reads
Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance.
Does not work on SQL 2000.
2011-09-28 (first published: 2008-03-19)
5,186 reads
Find every object in every database owned by a particular Login.
2011-09-27 (first published: 2008-07-07)
11,430 reads
2011-09-26 (first published: 2011-09-14)
1,833 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