Server: Msg 2812, Level 16, State 62, Line 37

Could not find stored procedure 'dbo.sp_MS_replication_installed'.

Server: Msg 21002, Level 11, State 1, Procedure sp_addpullsubscription_agent, Line 201

The Distribution Agent for this subscription already...

Hi,

  SQL 2000 and 3 x 40GB Databases trying to put. The application is ERP system

HI All,

  Thank you sooooo much for all of you.

Cosy

HI,

  Thanks, What i trying to do is sum all the Date_shpped by months

if date_shipped  '2007-07-04 10:-1:467' like in SQL so i can't sum and want to make it like this

        ...

Hi,

   Data is 50MB-100MB. But i know some of the tabels missing Primary key ?

so can we setup transactionl?

Hi,

Anyone use Reg Gate Product to do similer task? SQL or DATA Compare?

Hi Eddie,

Thank you so much for your information and your time.I got few questiont to ask and please help.

1. MS SQL STD Server Open License with Software Assurence @ 1850

    ...

HI,

 Yes, I got that and set to per seat 100 and per processor grayout.

But now i want to know is there anyway i can see that we got 100 CAL's?...

Hi

 Thanks, Now says 267. Is there any limits on SQL 2000 STd?

How  do i find how many user cals required for this server?

HI,

Thanks, But tell me how to setup this Performance Monitor and get the value?

HI,

 This says 248? So what is this number or is this make any difference to the SQL Server if so how do i find the bottleneck?

HI,

I got 52 SQL Jobs running in this serve? anyone run jobs from another server ( test Server?)

HI

Thanks, Can you tell me the values for above counters? I got Idera SQL Diagnostic Installed. So i can check it. 

Hi Michael,

    Thanks, I know lots of DB locks and system freez due to same sort of user action. I got eBO,eFO and eDistribution But running all 3 database in...

HI All,

    I'm a junior IT Support and looking for DR document to learn. If anyone like to send me a copy or give some idea much appriciate.