Hi

Dont forget jobs that are "still" running, ie. havent finished from when they where scheduled to run at 1am for example and its now 10am, this is a classic...

excellent points made, ill follow up on these and see how we go.

ok,

a hint forced it through, but i dont like it ! 🙂

<delete stateent> etc with (index(ix_enrolment1))

Hi

Although fine, its all overally complex for a simple task. I can never understand why people use everything else (like SQL*DMO), vb-script, extended stored procs etc etc to do...

Hi

I confirm LSCHOLL's support fix, also, use the SQL*Agent GUI properties for managing the proxy where possible to aleviate some confusion in the process, and always re-connect you sessions before...

Ok

Worked it out. I was using an alias in the linked server to the other named instance on the same box, I altered this to the actual named instance...

Hi all

>>EFS and all SQL Server 2k encryption options for views, stored procedures etc utilises the Windows Crypto API.

This is incorrect. A number of high profile security sites...

Hi

Search MSDN, then google, also see this website and sql-server-performance.com

Cheers

Ck

YES, you are perfectly correct and I have been using this method with SQL*Probes assistance to monitor the problem tables. It seem a good method but you skill need...

sqldesigner,

I will need to re-verify under a full domain model, but I dont believe you are correct re the data recovery admin group etc. The encryption key seems to...

Hi there

To honest, it was a very quick overview, and when i did I found the architecture somewhat confusing. Either way, I was convinced the key was part of...

Hi

But isnt that the key benefit from clustered indexes? where high selectivity is not necessarilya key requirement, especially for range scans? the Y,N one is fair enough but...

Hi all

OK, managed to repeat it on our support server, but its very spiratic. We have a large query, the programmer was running it via query analyser and was...

Table has a clustered index?

Hi

Please post the MS article URL for reference..

Cheers

Ck