Jorge,

Did you ever sort out a way around this? I'm trying to do the same thing. I've had to code it as a stored procedure but that makes my solution...

Thanks Dylan.

I'm not sure what you meant by setting up the identity ranges to be compatible but I think I might.

It likely won't apply to us, however, because if we do...

Cheers.

I actually got this correct but I think there was a typo in the question. I assume the question should have said the table was deleted at 11:55 am instead...

I have taken more than 15 Microsoft exams over the years (haven't failed any yet but have come close once or twice!). I definitely find Transcender to be a useful part of...

Interesting. Thanks!

Remi,

I hadn't even got that far with the user. I didn't think it was particularly relevant.

Thanks for your interest nonetheless. I don't think I need anything further.

- Mike

Thanks ... I was aware of the Identity/temp table solution but was hoping for a single statement solution.

It sounds like it isn't possible. That's okay ... I was just wondering.

P.S....

I thought we just had this question or something very close to it!

Carl,

I obtained my MCDBA about two years ago. I definitely feel it was worth it as it helped me move from a unsatisfying job to a fantastic one.

Like most DBAs, I...

When I said I had written over 15 exams, I meant I had taken over 15 exams not authored them as somebody asked me to clarify.

Jon,

I think your decision to take a Transcender exam was a good one. Don't worry too much about the 65%; it has been my experience that the Transcender exams are...

Michelle,

It has now worked for me. Just give it some time to load.

If you had tried earlier, you may need to hit refresh in the browser window comes up?

- Mike

Thanks everybody for the great comments. - Mike

Hi Steve,

This may be my own problem but when I went to open the May issue of SQL Server Standard (in PDF form), all I got was a blank screen....