As well as checkout the services started or not on both the servers.

Make them automatic.

Remote Procedure Call (RPC)

Remote Procedure Call (RPC) Locator

Remote Registry

Secondary Logon

Indexing Service(Dependencies RPC)

Type services.msc in run

Checkout parameters set in sp_configure for these below

remote access

remote login timeout (s)

remote proc trans

remote query timeout (s)

network packet size (B)

Thanks Gail.

Thanks for reply Steveb.

As the error above, I believe Enterprise Manager uses the msdb.dbo.sp_enum_dtspackages stored procedure to list the packages, so by examining this procedure you should be able to see what is...

I have this query to find out created table in last N days.

Select name, id, crdate

From sysobjects

Where type ='U'

and DateDiff(D,refdate,getdate()) < 7;

But it will get last created, I want last...

Thanks Gail,

I will try to work on that & will see the performance on Monday.

All the sql jobs are set on the servers by our previous DBA.

I read the article.

Its really interesting.

Ok.

I will change schedule of shrinking to weekly rather than taking daily.

Or i...

Today also i got an error for one database while shrinking.

Nothing is logged into error log.

I saw this error in the maintainance plan history.

-------------------------------------------------------------------

[Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 9001:...

Those jobs are set on server, runs daily.

Database state is online.

All the log files are there.

I got this error in early morning today for 2databases.

Yesterday i got it only for...

I want to move data/log files from C drive to E drive.

Is there any other option in SQL Server 2000 except of detach/atach

Thanks for reply.

Is there any way to do that except of doing detach/atach while copying from windows.

Hi all,

I am using sql server 2000

I am trying to use alter database option to move datafiles.

But it showed me error below-

Server: Msg 5037, Level 16, State 1, Line 1

MODIFY...

This is query which worked for me

BULK INSERT School_Lester.dbo.dbo_valCity

FROM 'D:\valCitynew.txt'

WITH

(

BATCHSIZE = 1000 ,

DATAFILETYPE = 'char' ,

FIELDTERMINATOR = ',' ,

ROWTERMINATOR = '',

MAXERRORS = 50 ,

TABLOCK ...

Hey Thanks,

BCP utility didnt work for me,

But i did it from Bulk insert & its worked for me.

Yesterday i started & within 5mins its completed while it was taking so...