For next time, know that you posted in a SQL Server 2008 forum. There is a SQL 2000 forum on this site as well.

OK, this was a known issue in...

What build of SQL Server?

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('ProductLevel') AS ProductLevel;

Have you...

Jeff Moden (9/5/2012)

---

First, done properly, there is no...

I recommend running in FULL recovery and taking lots of backups. If the rollout is multi-phased or prolonged then take a FULL backup at each logical stopping point. You can...

Jeff Moden (9/5/2012)

---

opc.three (9/4/2012)

---

Jeff Moden (9/4/2012)

---

opc.three (9/4/2012)

---

All sysadmins can execute any commands they wish and those commands will run in the context of the SQL Server service account, i.e. you...

A great supplement to BOL:

Comparing Table Variables with Temporary Tables By Wayne Sheffield[/url]

Yes, it does. It creates a new session outside the database engine as if it were any other data client...

You can output is as XML in grid view so it will appear as a link:

SELECT YourColumnName as [processing-instruction(x)]

FROM YourSchemaName.YourTableName

FOR XML PATH('');

Then click the link to see the entire text.

The...

Jeff Moden (9/4/2012)

---

opc.three (9/4/2012)

---

All sysadmins can execute any commands they wish and those commands will run in the context of the SQL Server service account, i.e. you lose the ability...

If you need fresh data then read the file each time in separate Data Flow Tasks, do the transformations you need and send the data downstream. This keeps most of...

You cannot restrict the commands...

I still don't know which two approaches you're comparing. Maybe if you explained your end-to-end process it will be more clear as to which two approaches you're having doubts about.

No. There is no difference.

A simple PowerShell script that opens a connection based on a DSN name would be my first thought to replace it.

Microsoft is guiding everyone into using the online version. I think I read somewhere that they have or will stop producing the downloadable version at some point.

SQL Server 2008 R2...