Ah. Well, not that then!

Verification as in mounting of the snapshots & DBCC CheckDB run against them?

This would cause TempDB...

Degree in Biochemistry but completely failed to get a related job after leaving university.

So after a couple of years doing odd jobs (driver's mate, pub chef, lab assistant, office clerk,...

Here's hoping so Steve!

Thanks. Don't like the sound of that!

Hi Ananda,

Without looking it up, I believe SET PARTNER FAILOVER is only allowed when the mirror DB is marked as being synchronised with the principal DB, i.e. all logs from...

What did it show?

When I compare the old and new objects in both sys.objects and sys.columns, its so convincing that what all the sysobject table[view] needs is a reference to the missing row...

Or Reporting Service has a field format of percent which would show 0.5 as 50%.

Don't think it's possible server wide.

You could create a template file with the localisation language set to en-GB and use that for new reports. Won't help you with the existing...

Theoretically (I'm not advocating doing it whatsoever), would it be possible to create an object, check if it has object_id = 780685979 then delete it?

Or would the extant rows in...

Jeff - no worries 🙂

I also find certs useful for gaining awareness of areas or features in SQL Server I don't use regularly or at all.

From a CV point of...

Don't know what are you're getting at Jeff? My four year degree in Biochemistry has served me well in my career as a DBA 😉

It seems to me Transcender is much more specific than the exam questions are, e.g it will question you on a specific fact/feature in sql rather than a set of...

Check the SQL Configuration Manager on the server - if there's a Reporting Services service listed then it's installed.

Or try going to http://servername/Reports (not definite answer though :)...