Last week one of my team members was supposed to create a SQL Authenticated ID on a SQL Server 2005 instance. This was as per the request of the Application team who would be using it for an Application.
2014-08-20 (first published: 2014-08-13)
1,927 reads
2014-08-18 (first published: 2014-07-28)
1,280 reads
2014-08-15 (first published: 2014-07-16)
1,575 reads
Restore script for moving databases from prod to dev with different path / logical name etc.
2014-08-14 (first published: 2014-05-30)
5,964 reads
If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.
2014-08-12 (first published: 2014-06-30)
4,144 reads
2014-08-11 (first published: 2014-05-28)
1,814 reads
This script was published originally on http://humakhurshid.blog.com/2011/07/14/script_out_fulltext_catalog/
The author has tweaked it little bit to improve it.
2014-08-07 (first published: 2014-07-02)
5,841 reads
The script below executes on the first of every month and moves files from source to destination location.
2014-07-24 (first published: 2014-06-16)
976 reads
2014-07-23 (first published: 2014-06-17)
1,787 reads
2014-07-22 (first published: 2014-05-16)
2,025 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers