Instead of restoring the database to the Production server why don't you think of settingup some kind of replication.

Can you please send the reply's to the form in the future.

Just to make sure can you double check if the user with which you are trying to start the SQL Agent services is in the local Admin group.

I am sorry, I mean How you are starting the SQL Agent services.

Can you give the details on how you are connecting to the SQL Agent.

We used to get this error whenever one of the clusters goes down(in the cluster environment with physical load balancing ).Once we fail it over then the error used to...

I think you try this too.

After renaming the database ,detach the database and attach it by changing the file names in sync. with database name.

Thankyou Steve your article answers all my questions.

Hope this works for you.

CREATE TRIGGER TR_InsertUpdate1 ON dbo.tblAddress

FOR INSERT, UPDATE

AS

DECLARE @CN VARCHAR(50), @ID INT

SELECT @CN = Company_Name, @ID = address_id FROM Inserted

IF @CN = 'UNIVERSITY'

BEGIN

UPDATE tblAddress SET

Column = 'TRUE'

WHERE...

Thankyou Antares it works.

I Have searched the article but could not find it,I think one of the hyperlinks are missing which can take us to the downloads section.

Thankyou Antares686 for your help.

correct.

I have come across this and did some research on it.even if you have the permissions of a DBO and not an SA user it creates the objects as if...

We customise a CRM package for associations (iMIS) and the application gives the provision for executing the stored procedures. Some how it is unable to recognise that the execution of...