When you say "it's Hung" does it mean that you are not able to acess from anywhere or just from client tool.  if you are unable to access it from...

Try here

http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us

Hope the folder path exists, also the folder+path name does not have spaces within it; I remember somebody pointing it in the past

Also, try having them on some other drives...

I would say, copy / generate the files from SQL Server to a file Share; and then have a .NET Code or some sort of code that reads the file...

Technically and Conceptually, you should not see any issues (per my knowledge)

The only thing you might run into is, when you run a LOOONG DML statement, where LOG file needs...

Hope this SCRIPT File and steps mentioned below will help in getting whatyou are trying for:

1. Create Folder say "C:\DB\CMD"   

    Save the below SCRIPT code as a DB.CMD file in...

If these 2 have different logical names associated with them, then try

1. sp_detach_db

2. Move the Physical files to required folders

3. sp_attach_db

Easiest way would be

1. Import the Entire File to TEMP SQL Table (Table to have Identity Column)

2.Delete TOP <nn> rows based on Identity Value

3. Delete BOTTOM <nn> rows based...

Hi Vinod

The screen shots might need to be changed, as thos product is now called SSIS and not DTS

Thanks

PP

Here is a solution(steps listed)

1. Change the schema, add another column say "PriorityOrder"

2. Insert all the values (initial data insert)

3. Create a Trigger on this table, such that if anybody...

SysObjects table has CRDate column and that should be starting point to check if any object was created in last 24 hrs.  Hope this helps.

Thanks

PP

Please note, you need to have ADMIN rights to run trace.

The only concern I can think of is, please ensure the backup really works, I mean the data that is backed up is relly loadabale.  This might be a stupid...

This is the code we had used in the past.  You can tweak this code to first check if the constaint exists, if it does then you may use ynamic...

Once the Index + Data gets moved to a new place, how can I verify this?

Is there any SQL that tells me that the data has really moved?