Used to be a security precaution, though some research from SANS on SQL 65 showed that the SID is always the same, to renaming isn't as helpful

I thought so, too

Thanks for the note, and not complaining to you, but trying to ensure you understand how we view the reports of bugs. The more detailed or exact you are, the...

You are quite welcome. If you have more questions on this, post again. If there's something else,or you get lost in SSMS, just ask. We're happy to try and help.

Welcome back, Barry. How are you? Long time no see.

We changed the points a few years ago, awarding different amounts for articles, for posts marked as answers, etc. A bunch...

Not sure if this will work, but from the secondary, try setting the partner off.

You really shouldn't trust my code, or anyone's, without verifying it.

You do need to learn how to do this,or get someone else to help you with this. While we can...

There is no easy way to do this with BULK INSERT. A CSV is comma separated. Formatting a number with a comma creates a separation to a new field. I...

PoSh is case sensitive.

I've downloaded those files and added them to the article in a zip file.

You can issue an ALTER TABLE ... ALTER COLUMN without rebuilding the table, even if the column is the PK.

CREATE TABLE dbo.Document
(DocumentKey NVARCHAR(5) NOT NULL CONSTRAINT DocumentPK...

It's still in process. Since we have a lot of these, a script needs to be written and tested to be sure we update items.

If there are specific items, I...

yw. Glad this is working today as we've had some scheduling issues with the questions.

We are posting all messages in UTC for now. Working on a display to show each user in their timezone.

It does seem like having the UTC time for everything would...

Thanks. Those links work for admins, but apparently something is broken in them for users.

There wasn't a message at the top of the article, but that's the only place there's...