CirquedeSQLeil (7/13/2010)

---

WayneS (7/13/2010)

---

WayneS (7/12/2010)

---

Fellow Threadizens - I'm having problems getting ssis pkgs/maint plans on a second (named) instance on a 2-node cluster running from the standby node. If you can...

CirquedeSQLeil (7/13/2010)

---

Wayne,

What are the service accounts being used for SQL Server Agent? (Domain, local, or network service)

Do you have logging enabled?

Can you open and edit the maint plans? ...

WayneS (7/12/2010)

---

Fellow Threadizens - I'm having problems getting ssis pkgs/maint plans on a second (named) instance on a 2-node cluster running from the standby node. If you can help, please...

SELECT Line1 = CASE WHEN Freeformat IS NULL THEN Flat + ', ' + House + ' ' + Number + ', ' + Street

...

LutzM (7/12/2010)

---

m.dunster (7/12/2010)

---

Ok, when I use the term 'adapted', what I really mean is change the table names to suit my database. 😀

Through your example for creating the data...I have...

You might want to check out this link[/url]

Please see the Cross-Tabs and Pivots, Part 1 and Part 2 links in my signature.

Did changing to the SQL Native Client driver help out? As I demonstrated, it seems to work for me.

1. How do you determine that it's missing, and that it belongs there?

2. You might want to read the article in the first link in my signature. Doing what it...

Fellow Threadizens - I'm having problems getting ssis pkgs/maint plans on a second (named) instance on a 2-node cluster running from the standby node. If you can help, please check...

When:

select name, modify_date from sys.servers

Who: someone with sysadmin rights; don't know how to tell who did it.

How about something like:

select top (1) TheFieldImInterestedIn

from TheTableIHaveToPerformMagicWith

order by TheFieldImInterestedIn DESC

Check constraints can utilize a function, so you might need to embed your max-field-comparison-between-two-fields logic in that.

Just...

-- See how you start off by actually creating a table

-- and then inserting the data into it? Doing this really

-- makes things a lot easier for all the...

It looks like if you change your provider to SQL Native Client, that it will work.

I ran this code in a database named "Sandbox", and both queries return the 600...