The code is tested at parsing time for all objects to exist;

it doesn't allow logical testing to be ignored.

you could switch to dynamic SQL instead to avoid the error.

IF exists

(SELECT...

well, the default trace only keeps the last 100 meg of DDL...

agreeing with Dave, it seems to work fine, but it assumes that MFM always exists and is always those three letters int eh first three chars.

if we are grabbing something...

Stating the obvious, a database doesn't just get set to single user by itself, some process or person actually issued the command.

that ALTER DATABASE command counts as a DDL operation,...

my SSMS for SQL 2012 is in this folder:

"C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

My question for you is whether you want to Replace the current call for SSMS with the 2012...

weekly updates screams drop and recreate to me; if you needed any changes/updates that were mere seconds old, it might be a...

if this was just an insert form the source, you'd ideally want to find a way to find the max(id/createddate) from the target, and get records that are greater than...

it's a quote, i...

The Dixie Flatline (5/30/2013)

---

GilaMonster (5/30/2013)

---

The Dixie Flatline (5/30/2013)

---

GilaMonster (5/30/2013)

---

I just delete that kind of thing outright, long with the 'Answer my posted question', 'explain life, the universe and everything to...

my wild guess to provide a rough example: note i'm truncating the time portion of hte datetimes to the day.

With YourTable

As(

SELECT 1 AS SomeColumnForGrouping,CONVERT(datetime,'2013-05-30 07:26:30.157') AS CreatedOn...

we have office365, so i just setup and tested a dbmail using it;

here's the scripted results, which will probably help you a lot:

i was in a rush, and named both...

in my shop, it would mean grabbing another backup of the "production" database and restoring it over the top of the Test Database that the developers and QA groups use...

i think it's the +90 INSIDE the datediff: '20130401' + 90 probably turns into either 20130491 or '2013040190', either of which are not valid datetimes.

maybe like this?

select *, '20'...

most likely permissions,

if you right click on that specific folder, and go to the security tab, you can see everyone who has permissions.

* Note that NT Authority\Network Service DOES NOT...

shew (5/30/2013)

---

[Background information]

I have a user who is convinced that his third party application is losing connection to SQL Server from a given app server (and the app will not...