I think we phone screened that person for a job once. Every question resulted in awkward silence, then some non-related babble, followed by an extremely well stated answer that...

FWIW, here is one such blog post about a workaround circa 2007:

http://blogs.msdn.com/b/mattm/archive/2007/09/13/capture-print-messages-from-a-stored-procedure.aspx

Are there any better options in 2011, almost 2012?

I am finding that with VMware back-end database, DBCC OPENTRAN reports that the open count is either 1 or 0, mostly 0. SPID 130 is tidily opening and committing...

What are some of the causes of this problem? How can we go about resolving it? Are we able to force that session to rollback?

Off the...

Thanks, Gail. With the SQL Server 2000 stopped, we could just copy the mdf/ldf files to the new machine and leave them in place on the 2000 server. ...

I get the feeling that Microsoft is large and sprawling enough that it's hard to know what different groups are all up to. I ignored LINQ for the first...

I am a .NET developer with a lot of SQL Server 6.5 and onward experience. I have never been called a DBA but I have functioned in that role...

wildh (9/23/2010)

---

Is this any good - http://facility9.com/2009/04/23/populating-us-federal-holidays-in-a-calendar-table/

or -

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

We have a similar issue in the UK but it's only a 10 min job to crib it...

This is the master...

Someone should really make a list of US Federal Holidays. You would think that data.gov would have something like that.

As many have done before me, I ended up making...

I tried explicit conversion inside the Jet SQL but I don't think this is helping much:

SELECT ID, CSTR(Description), CSTR(TextDescription) FROM [Sheet1$]

I think I need to get back to the root...

I also want to add links to these 3 blog posts because there is much more detail. I still do not have the magic way to take 1000 general...

I know it's common because I've been having to convince colleagues it's a real issue and I am not crazy for 10 years. I am grateful to now know...