James Goodwin (9/20/2011)

---

This line in the article struck me:

In the context of coursework this is true because the point of...

Wow, was sure I'd drop another one, but Vincent Jackson and Jeremy Macklin came through.

I might be up for some type of trade if Bryan comes back next week. I...

You can't add a letter in the column. You could create a computed column that includes the identity as a component (http://voiceofthedba.wordpress.com/2011/08/30/computed-columns-and-udfs/), but it could help if you explained if...

Please let's not have quotes of every post that counts down from 95, 94, 93.

I'm going out of town for a few days. I'm hoping that I don't have 300...

have you checked the SQL Server log on the remote machine. Is it listening on 1433? When SQL starts up, it will let you know where it is listening.

That is the only way to put SQL Server in single user mode. Have you checked the error log to see what might be happening?

In answer to your question, no. If the row takes up > 50% of the page, you get 1 row per page.

If you use varchars, you might end up with...

Are you looking to duplicate the affected tables? If you wrapped it in a stored proc, I believe the Red Gate Dependency Tracker would tell you which tables, and then...

Closing this thread as a duplicate.

Please do not attack other members when they post. Regardless of your time critical situation, this is a volunteer forum. If you do not like...

Change the password requirements for Windows 7. http://windows.microsoft.com/en-US/windows-vista/Change-password-policy-settings

CREATE TRIGGER myTrigger ON myTable

AFTER UPDATE

AS

BEGIN

If UPDATE(column1)

-- returns "new" updated value

select column1 from inserted

-- returns old, pre-update value

select column1 from deleted

There is a shared lock (S) on the data, but that prevents exclusive locks being placed on the page/row/table for changes. It doesn't impact read performance.

As you noted the data...

Ugh. Tim Mitchell had something similar that he did in a presentation to skip headers when using SSIS, but you could easily redirect the headers to another table, as Sean...

I don't think there is a way to do this. You could make a SQLCMD batch file and use that.

I thought that you could specify the default db location in setup and all databases went there, including system ones.