How to move the FullText catalog with SQL Server 2005 ?
4 simple steps to move FullText catalog with SQL Server 2005 :-
1. Detach the database which contains the FullText Catalog....
2012-10-12
1,084 reads
Introduction to SQL Server 2008
There are still some seats left on the SQL Server 2008 A Comprehensive Hands-On Introduction that I will be presenting...
2012-10-12
577 reads
24 Hours of PASS Recordings Online
This just in… the 24 Hours of PASS sessions are in and available for streaming. If you missed an hour...
2012-10-11
1,034 reads
2012 PASS Elections Letter Of Recommendation From Ed Watson
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
1,050 reads
2012 PASS Elections Letter Of Recommendation From Stacia Misner
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
676 reads
Windows Server 2012 and Hyper-V
I recently went to a Microsoft event in Denver on Windows Server 2012 and Hyper-V improvements. Harold Wong (b | t)...
2012-10-11
1,378 reads
2012 PASS Elections Letter Of Recommendation From Jes Borland
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
645 reads
Do you Dream?
You ever have those nights consumed by all things SQL? I do. It happens more than I might like sometimes. Usually it happens when there is a work problem...
2012-10-11
13 reads
Do you Dream?
You ever have those nights consumed by all things SQL?
I do. It happens more than I might like sometimes. Usually...
2012-10-11
943 reads
SQL Server : Index Part 1 : Basics of index
While conducting interviews , I have noticed that, many people does not have clear picture about index.Many of them does not...
2012-10-11
1,393 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
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