Bill:  Don't tell me, the power was off but your daughter still wanted to use her computer, so she lit a candle?

Or ...

Absolutely. That's just one reason I carry a laser pointer with me everywhere I go, even to the beach, along with my cellphone, PDA, scientific calculator, Leatherman tool, GPS...

This is interesting. Profiler says that sp_MShasdbaccess is taking a long time. This presumably is the proc that populates the dropdown list of databases in QA. It...

Mark: Thanks for your reply, but sp_dboption returns OFF for all databases on that server.

Mike:  Only the true pedant will always tell you why you should do something, so I did. 

You don't have to SET NOCOUNT OFF at the end of a stored procedure because that ends the batch and the value of any previous SET will be restored.

Also, some system procedures like sp_executesql call for nvarchar parameters. If you're a neat freak like me, you define your variables and constants as nvarchar so there...

Thanks so much, sushila. I knew there was a correlated subquery in there somewhere, but couldn't figure it out.

Thanks, sushila. That didn't show up in the first thousand or so of my google search, but it looks like exactly what I needed.

I agree, it is a presentation layer issue. I am just trying to help out the GUI coders by getting the mask for them and stashing it in the...

--What I have done is set up a table of business days:

CREATE TABLE BusinessDays (PK int IDENTITY(1, 1) primary key clustered, BusinessDate smalldatetime)

--Then I load it with the dates of...

bcp will write the resultset of a query out to a file. So whatever the result of that query happens to be at the time of execution will be...

Are times a part of the data?  This returns the last possible datetime value on the last day of the previous month:

select dateadd(day, -1, convert(char(6), CURRENT_TIMESTAMP, 112) + '01 11:59:59.997PM')

This...

Can you alter the table into which you are bcp'ing the file to add an identity column on which a clustered pk index has been established?

CREATE TABLE YerTable (

Field1 char(10),

Field2...

Bryan: The information_schema views will give you lists of columns and tables, and the diagramming tool will give you a "pile of shirt hangers" view of your database. ...