[/quote]

nope, that would be expected, you would have to physically import the package into msdb (via SSIS) to se it in msdb.

msdb is usually the better place to store packages,...

george sibbald (7/16/2013)

---

each node with two instances gives you 4 instances, and that is very much active\active, or as I believe Microsoft would officially call it, a multi-instance cluster.

You will...

george sibbald (7/15/2013)

---

@DHeath

@peacesells

SQLAgent jobs are held in msdb and there is only one msdb per instance. You seem fixated on the nodes, is this a failover cluster with...

george sibbald (7/15/2013)

---

clusters use shared disks, there is only one copy of all the databases, connect to them using the virtual sql instance name (thats why its called virtual, it...

george sibbald (7/12/2013)

---

the name of the SQL service in the cluster, i.e. the name you use to connect to the database engine.

The packages are normally imported to msdb, thats better...

Thanks George.

When you say virtual sql server Name - is that the cluster name or would that be names of the nodes....

david.alcock (6/10/2013)

---

Maybe have the two destinations set up in connection manager.

You can then run a count in a SQL task that in turn populates a variable. You then have...

LinkTable1, LinkTable2, LinkTable3 ...are different fields in the table...

Evil Kraig F (5/9/2013)

---

You have to RDC to the box, rt-click computer, manage, and check the services. Rt-click services and in properties for it you'll be able to see...

Evil Kraig F, I have no clue. Its our production box and i doubt if i have...

GilaMonster (3/29/2013)

---

Because GO is not a T-SQL statement. It's a client tool command. SQL Server has no idea what it means.

Split that into two pieces of dynamic SQL, one that...

Here is the Code Snippet

...

opc.three (3/25/2013)

---

You could do something with Dynamic SQL and a DDL Trigger, but that would be code-compiling-code-that-it-wrote-on-the-fly which can be difficult to write to where it works properly in all...

Thanks Lynn,...

sunder.mekala (2/20/2013)

---

if i go woth your suggestion then i need to group it by the other non aggregated columns, if i group it my results will go wrong, so i...