found a round about

Update the sysobjects and set the xtype to 'U', add the trigger and set the

xtype back to 'S'

Problem is solved.

I just activated the "auto start SQL agent if unexpectedly stopped" in the enterprise manager -> management -> SQL Server Agent-> Properties -> advanced

Thanks

Its is on the server.

The first option meets my requirement.

Thanks for the suggestions.

This is a bug which has been fixed in Service Pack 2. Both the servers have Service Pack 4 installed . Still the problem. Strange.

The existing SQL Server default agent...

How can I change the login timeout and Query time out setting for Log Reader Agent in Enterprise manager.Not finding any example(Query) in books on line

Thanks

The first two options ( Log reader and SQL Agent Stop) has been tried out.No success.

How do I extending the timeout for the log reader.

Thanks

Thanks for the immediate reply.

Oracle : 8.1.7

The problem is sorted . There are three DLL which needs to be registered on the system where Oracle client is installed.I got the...

The datatype and the lenght of all the columns in the Publisher and subscriber is the same.What i am suspecting is the data for one of the column which has...

Change the memory setting to Dynamically configure SQL Server memory on the server

Set the min to say 20MB and similarly Max leaving 20MB.

Try connecting through QA

Mouli

create table testtablesize (col1 varchar(8000), col2 varchar(35))

Message:

The command(s) completed successfully.

create table testtablesize (col1 varchar(8000), col2 varchar(36))

Message:

The total row size (8061) for table 'testtablesize' exceeds the maximum number of bytes per...

Well irrespective of the datatype (char or varchar) the message is the same that the row size cannot exceed 8000 bytes.Can some one check and answer this please.

Mouli

...

U R creating the database on E drive

Check whether the directory "test" is present since the file testdat.mdf is supposed to reside finally in e:\test\ ,

If it does not...

quote:

---

Try SQL Probe ?

---