Thanks it worked

Thanks for your help Guys. you are a great help. Happy Holidays

Thanks you Guys for your valueable input. I re create all the Indexes and and increase number of lock to the database its seems to be working now. I really...

Its SQL Server 2000 on Window2000, Np. I really appreciate your help.Thanks for the info.

I schedule this proicedure to run 6 Am and there is another job on another machine which runs about 5 Am and completed around 5:15 and feed Data...

Here is the procedure, Some time its runs fine and some its fails.I dont understand why?.

CREATE PROCEDURE [sp_lossrun_web_sub] AS

/** Submission Clearence **6/22/02**/

/** delete table info and add new data...

Thnaks for the info, Is there is Any problem if I have choosen Append teh transaction Option In my backup?. One more thing before restoring on new machine Should I...

Rcosta,

Thanks for your help. Yes I do have good recent backup.

Hi Rcosta,

can you pl. provide me the complete sytax ro command for me to do that. Thnaks fro your help.

Hi All,

Thnaks fro your valuable inputs. I think I found the issue. I don't know how but when I I count number of indexes its not matching on both...

Thnaks fro your valuable inputs, Can you Pl. tell me how I can check I have number of indexes same in both the datbases. I also needs to know...

Steve,

I try to dettach and attach through SQL SERVER ENTERPRISES manager, But I don't know why when I right click on DB the all tass my Dettach option is...

Steve,

I am trying to use Enterprises Manager GUI- Copy Database wizard and getting following Error. Any work around

setp error source: Microsoft SQL-DEMO:

SQLSTATE:HYTOOO

Step error description : Microspft ODBS SQl...

I use All object option while export, I dont know why its just copied tables and views only. Any way does any one know any better way of making a...

Hi Guys,

I am new to SQL server Administration, Can some one post step by step guideline to moce a SQLSERVER7.0 database from One machine to another machine of SQLSERVER2000. I...