Hi here is the SP I run and the execution plan of the code only run hope it helps. Please let me know if you need more information.

Thanks for all the help so far. When I try to get an estimate execution plan on just the code it gives me this error:

Msg 208, Level 16, State 0,...

I did create a new sp under new name with recompile. This did exactly the same. Even trying to get estimated execution plan on the sp runs more than and...

Yesterday afternoon I got the SP to run in 1 min by substituting one of the join with temp table. This works fine but what I do not understand is...

the log file is under th log directory but is not displayed by SQL log viewer.

example

exec sp_temp - this times out

code from sp -

select * from t1

join viewa on a=b

join t2 on c=d

this executes in 30 sec

Forgot to mention that the physical file has data in it.

There is different types of audit. what do you whish to get from the audit data?

I have had the same problem that it fails but it was always intermediate. Some systems will safe correctly and some not. The systems that it worked on is sql...

It is a risk if you have someone that wants to be milicious, he can steel information or remove important data that will cost you time and man hours to...

Hi

I have seen these manual encryption procedures but why would you want to use it. It is going to cost alot of work to get it working and maintain it....

You can use the following to check where you duplicate records is.

select d.vcrEmployeeSignOff,

d.vcrManagerSignOff,

d.vcrSendForReviewSelfAssessment,

d.vcrManagerReviewSignOff,

d.vcrSelfReviewSignOff,

d.vcrComnMgrSignOff,

d.vcrCommEmployeeSignOff,

d.vcrCommSkipMgrSignOff,

d.vcrCommHRFeed,

d.vcrCommSendToTM,

d.vcrpriority,COUNT(*) from tblstatusmaster d

group by --c.vcrSendForReviewGoals = d.vcrSendForReviewGoals and

d.vcrEmployeeSignOff,

d.vcrManagerSignOff,

d.vcrSendForReviewSelfAssessment,

d.vcrManagerReviewSignOff,

d.vcrSelfReviewSignOff,

d.vcrComnMgrSignOff,

d.vcrCommEmployeeSignOff,

d.vcrCommSkipMgrSignOff,

d.vcrCommHRFeed,

d.vcrCommSendToTM,

d.vcrpriority

having ,COUNT(*) > 1

This sounds like a problem with AD security that changed or maybe a group (normally the local\administrators) that was removed disabled on the SQL instance or server security.

What happens...

The reason for the maint plan not working is that the pointer to the deleted database is saved in the package and not automaticaly updated. As mentioned you can just...

This is a problem with SQL 2000 SP upgrade. What SP are you using on the SQL2000 server. To fixe run the following scripts Instcat.sql on the 2000 server. For...