My psychic powers predict that the login you were using to run the procedure had a language setting defined which determined the default format when casting a DATETIME to a...

The difference between RECOVERY and NORECOVERY is, briefly, that RECOVERY rolls back any uncommitted changes (this is called UNDO). This makes the database consistent again so it can be...

Assuming that the client connected to the SQL Server over TCP/IP then normally , yes.

It depends on what you mean by 'last operation committed' though.

Perhaps you could expand on the...

:doze: Sometimes it is better not to post at all...

Anyway, this is a good place to start: Maintenance Plans

Mazharuddin Ehsan (9/10/2009)

---

For a requirement like 'for numbering lines in a file' the row_number() will not be suitable because it needs an OVER and Order by Clause. This task can...

A super fast response from Sunil Agarwal on Connect.

Sunil Agarwal

---

Thanks for contacting us. You will notice that with ONLINE, we are adding an extra byte at position 2 in the...

It makes you think, doesn't it.

SET NO COCONUT ON;

GO

I hope you mean for SQL work! :laugh:

Thanks very much! :w00t:

...o.O

I can't have been away more than ten minutes...:w00t:

Thanks for the egg recipes!

How can I boil the perfect egg?

:laugh:

Ian,

Cool. Thanks for the exchange - great stuff. And it's 3am. Time for me to hand over to the next time-zone... 🙂

Awesome. Sorry about the interruptions - but Ian and I are having a fascinating discussion, hope you didn't mind too much :blush:

Nice post Ken. I can relate.

Personally, I do prefer the questioner to make some effort - if only so I can understand the request.

I'm not above writing the test...