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.

If you have systems center, or an equivalent, or want to do WMI scripting, you can probably initiate scans across your various Windows hosts to get a list of all...

I think learning those obscure items, and understanding those can make life richer and more interesting. I'm surprised sometimes how things from other subjects impact the way I look at...

There are a few ways to handle this.

The easy way is to use SQLCMD and a little scripting to connect to each database in turn and run a script.

One is...