When you run this as a script - it will run in the context of the database you are using. When you create it as a stored procedure, it...

Seggerman (2/19/2009)

---

I had this problem at an earlier job and it was a dog - arf! Making the WHERE select into a temp file helped a bit. If...

I would recommend using Redgate's SQL Data Compare instead of writing your own. But, if you don't want to go that route:

1) Create a linked server from one system...

DECLARE @seconds int;

SET @seconds = 14400;

SELECT DATEADD(second, @seconds, '20090101')

,CONVERT(char(5), DATEADD(second, @seconds, '20090101'), 108);

Ahhh, yes - should have been clearer and stated that it shows up under logins. If you script the login, you will see the difference.

For windows users it will...

Yes - that is correct, if you count the private addresses needed for the cluster heartbeat connection. Forgot about those 🙂

If you look at the properties of each one of those users, you will see that the user with the instance\username is a windows user and those users without the...

At a minimum, for a two node cluster hosting SQL Server you are going to have four IP addresses.

One for each node

One for the virtual cluster name

One for the virtual...

If you do run into a performance issue using the structure:

WHERE (column = @parm OR @parm IS NULL)

You can either move directly to Dynamic SQL, or you can try using...

andrewd.smith (2/11/2009)

---

If OP wants to select records where the date range in the table row overlaps the date range defined in the input parameters, then Vladan is right, and rtomkins'...

What you have left to do is not going to be easy. Especially since you have no reliable method of determining that the first element in the space delimited...

As written - your trigger is only valid when you can guarantee (for all time) that there will only ever be a single row updated at a time.

If you try...

Sorry - that is a typo, it should be COALESCE.

Because you are not referencing the table CFD in the from clause. You need something like:

UPDATE a

SET {columns}

FROM CFD AS a

...

Lookup GROUP BY and COUNT in Books Online.