How could do I such thing?

Dear gurus,
I'm doing a Visio document and I was wondering if from there is possible
open a DTS. I mean, as a "\\" path or any "http:" url.
Does anyone ever used or experienced with this kind of interactivity?
Thanks in advance for any input,I wasn't aware you could actually open a DTS package as a Visio
document.|||If I understand you objective, click on a drawing object to select it.
On Menu Bar, click Insert. Click 'Hyperlink' menu item and enter
appropriate information.
HTH if this is what you need?
gary bsql

How Change FullText Path?

We needed to change the drive path for one of our SQL
Server Instances. All system databases have been changed,
but we are having trouble changing the FullText. We have
edited the Registry, but the FullText service still fails
with a path error when attempting to bring online within
Cluster Administrator. What are the steps to changing the
FullText path?
| Content-Class: urn:content-classes:message
| From: "michael [multnomah]" <anonymous@.discussions.microsoft.com>
| Sender: "michael [multnomah]" <anonymous@.discussions.microsoft.com>
| Subject: How Change FullText Path?
| Date: Tue, 5 Oct 2004 19:32:51 -0700
| Lines: 7
| Message-ID: <0f0501c4ab4c$c7058b30$a601280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| thread-index: AcSrTMcFUHcHTCYIRLe5RnswyCyFGQ==
| Newsgroups: microsoft.public.sqlserver.clustering
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.clustering:15145
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.sqlserver.clustering
|
| We needed to change the drive path for one of our SQL
| Server Instances. All system databases have been changed,
| but we are having trouble changing the FullText. We have
| edited the Registry, but the FullText service still fails
| with a path error when attempting to bring online within
| Cluster Administrator. What are the steps to changing the
| FullText path?
|
################################################## ###########
Hello Michael,
Have you gone through the following KB artilce that discusses how to move
full text catalogs:
240867 How to move, copy, and back up full-text catalog folders and files
http://support.microsoft.com/?id=240867
If the above does not seem to help you, then you can go about rebuilding
the full text resources in your cluster environmnet using the steps in the
below KB artilce:
812666 How to recover a failed full-text search resource on a clustered
http://support.microsoft.com/?id=812666
HTH,
Shashank Pawar
SQL Server Support Engineer, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.

How can we modify the files path for the database in database engine?

Hi, all experts here,

Thank you very much for your kind attention.

I am trying to modify the files path (primary file, log file) of databases, but it looks like I am not able to mofidy their files path directly from the database property dialogue? Would please any experts here give me some ideas on what else can I try to figure it out? Thanks a lot in advance and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

I don't think it's possible to modify file paths when the database is active (read only)

I'd suggest DETACH, RE-ATTACH with different file path

should take < 1 minute

|||

You can not just change the path. You have to either detach and attach the database or backup and restore the database. Detach and attach will be faster and easier with less chance of data loss.

Both options are offline procedures.

|||

Hi, all,

Thanks a lot for your kind advices.

With best regards,

Yours sincerely,

|||Hi Helen,

You cant change the filepath when the database is in online. When sqlserver starts it will check for the path of database (from sysaltfiles tables) and it will start accessing the files. Once the database is online it will lock the file (you cant even copy the physical file through OS).

You can detach the db and move the physical file to the path you needed and the attach the db. It will work fine.

The above description is only for user dbs.|||

Hi, Sagar,

Thanks a lot for your very kind advices and help.

With best regards,

Yours sincerely,

How can we modify the files path for the database in database engine?

Hi, all experts here,

Thank you very much for your kind attention.

I am trying to modify the files path (primary file, log file) of databases, but it looks like I am not able to mofidy their files path directly from the database property dialogue? Would please any experts here give me some ideas on what else can I try to figure it out? Thanks a lot in advance and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

I don't think it's possible to modify file paths when the database is active (read only)

I'd suggest DETACH, RE-ATTACH with different file path

should take < 1 minute

|||

You can not just change the path. You have to either detach and attach the database or backup and restore the database. Detach and attach will be faster and easier with less chance of data loss.

Both options are offline procedures.

|||

Hi, all,

Thanks a lot for your kind advices.

With best regards,

Yours sincerely,

|||Hi Helen,

You cant change the filepath when the database is in online. When sqlserver starts it will check for the path of database (from sysaltfiles tables) and it will start accessing the files. Once the database is online it will lock the file (you cant even copy the physical file through OS).

You can detach the db and move the physical file to the path you needed and the attach the db. It will work fine.

The above description is only for user dbs.|||

Hi, Sagar,

Thanks a lot for your very kind advices and help.

With best regards,

Yours sincerely,