Forum Replies Created

Viewing 15 posts - 1 through 15 (of 22 total)

  • RE: Web Assistant privileges Privileges

    I am not able to get the Web Assistant Wizard option when i click on Wizards Tool button.

    It only comes if i loging to server in Enterprise Manager as sa.

    But...

  • RE: IIS and DB server on different domain.

    I tried using the IP address in the connection string, but its not working. Also the domains are trusted. but still its not working, do let me know if there...

  • RE: IIS and DB server on different domain.

    Hi

    We have tried using IP\intance_name in the connection string, but it is not working, as i said the boxes are on two different domains which are trusted on one Windows...

  • RE: Controlling Agent jobs from T-Sql

    In SQL Server 2000 i use to query on sysjobs, sysjobhistory tables and find when it was last rum ,or whether the job i s already running and whether it...

  • RE: Job restart on condition

    Yes u r right u can do so buy updateing the next_run_date and next_run_time fikled, but be cautious as these filds in the tables are int, now dont ask y...

  • RE: Missing PK mark(s)

    If u have use DTS Import/Export Wizard and said that create the constraints at destination table it does not create tge constraints using the wizard. If i need to do...

  • RE: Simple Database Recovery Model

    Check out the Truncatte the log on Chkpoint, havent worked then also give a try

  • RE: Scheduled Package Errors

    u can find out in MS SQL Server 2000, by making package log execution to the server option true in the package properties and then quering the sysdtspackages, sysdtssteplog and...

  • RE: The agent is suspect

    Thnks guys for al ur help

    I have sloved the problem by making the agent run in a cyclic fashion

    and i will also try putting up the replication alert

    Regards

    Jay

  • RE: The agent is suspect

    Hey , can u tell me how to restart agent automatically, if u can tell me that , just gr8.

    Thnks in advance

  • RE: The agent is suspect

    ya notifying is fine, but what if i am not there i n the office, or i am at a place where i cant connect to the server, then i...

  • RE: The agent is suspect

    No sir, the merge agent was failing and it was saying that The agent is susupect, No action to be done in the last 10- minutes, I had to restart...

  • RE: different table names ?

    I guess if the replication is only one way, that is insert into ur tables should do the insert into there tables, then u can change the MS replciation procedures...

  • RE: Chang in column design haiving Transasactional Rep

    quote:


    Easiest way is to drop the publication, make the change, then re-snapshot. You can shortcut some by stopping the logreader, making sure...

  • RE: DTS package in a cursor

    quote:


    Two things,

    1) It looks like you're using the same filename for each record. Does the file get deleted successfully? Maybe your email...

Viewing 15 posts - 1 through 15 (of 22 total)