Richardyager (8/2/2012)

---

I would use the maintenance plan wizard in SQL Server Management Studio. This is an easy tool to use. And it will automatically grab any new databases. You can...

Think twice three times before enabling xp_cmdshell. Enabling it exposes functionality on your SQL Server instance that are better left disabled, which Microsoft agrees with as xp_cmdshell has been disabled...

Tatsu (8/2/2012)

---

opc.three (8/1/2012)

---

Were you continuing to run your 2008 packages using dtexec 10.0? From the file system or were they carried forward in the upgrade and allowed to stay in...

Michael Lato (8/2/2012)

---

I am trying to set up some upgrade scripts using sqlcmd but I need a graceful exit from the script under certain conditions (i.e. wrong database version). ...

I bought software from these guys years ago, and still use them for price compares all the time because their URL is so easy to remember, probably because it reminds...

mmgorman (8/2/2012)

---

I have an existing Person table with about 4 million rows.

I have an existing PkeyColumn, PersonId, that has values from say, 1 to 4,000,000. PersonId does NOT have the...

jeff.mason (8/2/2012)

---

So why bother making replication able to replicate schema then? There is only one schema change that replication cannot handle -- dropping tables that are part of a...

jeff.mason (8/2/2012)

---

opc.three (8/2/2012)

---

This is exactly what Microsoft is up against. They...

This is exactly what Microsoft is up against. They have to...

Ian C0ckcroft (8/2/2012)

---

Thanks opc,

that is the article I used to dev with and then I tried all different options.

i ORIGINALLY USED

SELECT *

FROM __InstanceCreationEvent WITHIN 1800

WHERE TargetInstance ISA 'CIM_DataFile'

...

jeff.mason (8/2/2012)

---

opc.three (8/1/2012)

---

It's a least common denominator approach. If SSMS were coded to account for every permutation possible to arrive at the most efficient way to add a column think...

I hadn't known of it before but Shell looks promising. Please let us know how it goes. I see there are some challenges in deployments when running unattended.

iBar (8/2/2012)

---

opc.three (8/1/2012)

---

The EAV model is an anti-pattern when attempts are made to apply it as a 'more flexible' replacement to a proper relational design. There are certainly places where...

You posted this in the Integration Services forum so why use bcp? Why not SSIS? If you do in fact need bcp you'll have to use a format file to...

You can use LIKE with WMI. I would recommend modifying your query to use TargetInstance.Path, TargetInstance.FileName and TargetInstance.Extension instead of TargetInstance.Name for performance reasons. Using .Name as you have it...