I agree with others who've posted that this approach, as listed, is bad practice.

Instead, I would direct readers to the links below, which explain how to shrink a log file...

Great question! It can be used in several different ways to learn more about variables and assignments, and versions of SQL Server. Thanks (even though I got it wrong...

Nice question. Thanks.

- webrunner

Great question - thanks. I probably would have gotten it wrong had I not seen "type_desc" so many times before. 🙂

- webrunner

Great points.

I realize this is no substitute for wisdom and experience, but I wonder if at least there could be a workflow to adding logins to the sysadmin role. In...

My general approach is:

1. If it is a coding problem, I try to come up with my own way so as not to just copy what someone else has done....

If you still need this info (and if it hasn't been wiped out or otherwise lost), perhaps there is a parallel system that logged this info - OS for the...

"It always affects the fantasy baseball league. "

This is true, deadly serious, and should not be made light of. Except, of course, when the World Cup Pick 'em takes precedence.

:-p

-...

Hugo Kornelis (7/28/2014)

---

I realized that #Employee would not be available in the context of the bcp command, but had to do some digging to predict whether that would result in...

I also picked D. Not sure if it's correct, but it seems the way the process would work.

- webrunner

I'd like in if there is any room left.

Thanks,

webrunner

FYI I got this error:

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '('.

Msg 137, Level 15, State 2, Line 8

Must declare the scalar variable "@ts_now".

Msg 156, Level 15,...

Mark Fitzgerald-331224 (7/15/2014)

---

This is two's complement numbers being used.

When converting down from varbinary to an integer data type you only get the last (least significant) byte. In this case...

Plagiarism is always a risk, especially when a community is set up like SSC and allows users to submit articles. It's a shame to see plagiarism, but I commend SQL...

Thanks for this script!

It works great on SQL Server 2008...