TommyB (10/12/2007)

---

To drop the catalog (do this first) -

DROP FULLTEXT CATALOG catalog_name

Then try the steps above again.

To determine SP level -

SELECT SERVERPROPERTY('productversion'),

SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Should...

TommyB (10/12/2007)

---

To drop the catalog (do this first) -

DROP FULLTEXT CATALOG catalog_name

Then try the steps above again.

To determine SP level -

SELECT SERVERPROPERTY('productversion'),

SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Should...

TommyB (10/12/2007)

---

Haven't seen that one. Are you running SP2? SMO issues within management studio can typically be alleviated by shutting down managment studio and reopening it. You can drop...

Tommy,

I think that we are starting to make some...

Tommy,

I do NOT have a backup of the full text catalog...

Tommy,

First of all thanks for your post.

Does that article pertain to SQL 2005.

Is that really the EASIEST way to change the path for a full text...

Michael,

That is a good idea.

I will give that a try.

Thanks.

 

Rick Bellefond

 

 

Bill,

Oops, I meant to post

ALTER DATABASE RB_Data_Services_MSCRM

SET MULTI_USER

Any idea as to how I can get exclusive control over this db so I can then rename it or delete it?

Thanks.

 

Rick

Mohammed,

Ok, I actually got it to go into multi user mode by going to Services and restarting the SQL Server and then giving it the

         Alter database RB_Data_Services_MSCRM

         Set multi_user;

command...

Mohammed when I tried your script I got the message saying

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '-' -

Was I supposed to change @DataName to the name...

Mohammed,

When I try to put the db in multi user mode I get:

Msg 5064, Level 16, State 1, Line 1

Changes to the state or options of...

Mohammed and Yelena,

You guys are amazing.

Thanks.

 

Rick Bellefond

 

Oh, that does not sound good.  So while I thought that I was making a backup to a single file I actually made it to multiple files.  The only backup...

Tuned out that I just needed to go to IIS and start the website and make sure the website was started.

Thanks to all who provided input.

Rick Bellefond

Michael,

Ok, thank you.

Rick Bellefond