I've managed to get this to work by installing the full blown Visual STudio 2008 Professional Edition.

ANyone know why the "Start Debugging" menu item would NOT be enabled? I would like to debug an SP but all of the Debug items like Break Point insertion...

Additonal INfo:

IN case it matters, my reason for this is so that I can compare the Chekc Out date for the Prior Guest to the Check In date of the...

Not to be critical of the more skilled folks in this forum but even the most thought out and heavily reviewed & approved advice could still prove to be bad...

UPDATE #2:

I managed to get this work, at least partially. If I explcitly turn on the 3 SET OPTIONS (that my app turns off) within the definition of...

UPDATE: More Details Found

I have tested this by imittating the application by logging in under teh same SQL Login but what I did not test/do until just a few minutes...

I used the code found at the Robyn Page & Phil Factor DDL Article at http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ddl-trigger-workbench/. I've included the link here instead of just re-pasting the code.

I did also...

UPDATE: More on this ....

Just as an FYI I have discovered thru testing that the differences between the 2 methods greatly lessens with each increase of the number of pieces...

Carl Federl (6/19/2009)

---

Ran your two SQL statements and there are differences in both the statistics io and query plans. But the two SQL statements are not logical equivalent. ...

GilaMonster (6/19/2009)

---

YSLGuru (6/19/2009)

---

There may not be enough here to answer my specific situation but in general, isn't it true that when all conditions are equal, a sub-query version of a...

MORE ON THE SUB-QUERY vs DERIVED TABLE

Here are the results of STATISTICS IO for the 2 methods. I have changed the table names (except for Worktable) to be...

Ian Scarlett (6/19/2009)

---

If you don't like the idea of SSIS or Powershell for this task, you could use good old fashioned xp_cmdshell.

It's a bit clunky, but it's possible to load...

FNS (6/19/2009)

---

I'd write (aka download from google) a vb script to do the job then either use Windows scheduled task widget to run it or create a DOS batch file...

Grant Fritchey (6/10/2009)

---

YSLGuru (6/10/2009)

---

Thanks for the input but after spending a couple of hours (yet again) on Powershell, persuing the Microsoft PS specific sites & Googleing on PowerShell for sample...

The real answer to thsi issue of should I go with the smallest data type possible (for space & badnwidth reasons) or to go with what is portable and or...