Stolen directly from BOL:

INSERT INTO docs SELECT 10, xColFROM    (SELECT * FROM OPENROWSET       (BULK 'C:\temp\xmlfile.xml',    ...

Not so much the account per se - it's in the e-mail configuration.  It wouldn't matter what application it was - the message implies the config itself isn't quite right.

Try...

That's not a SQL issue per se - that's purely an e-mail configuration.  SQL relies on the e-mail profile you picked to be set up "right".  It's just passing back...

I understand not being able to pre-process outside of this procedure, but have you considered just using actual tables that get rebuilt with this data (at the tope of the...

...or in the same way - if the query has something like a TOP statement (like, select TOP x ....) it could cause the same type of limit.

If you don't store sequence info - how are you going to prevent infinite loops?  With what you're advocating - it seems to be only a matter of time before...

What Micke is advocating is what is called an "active/active" cluster.  During normal times, one node runs one of the instances, the other runs the second instance.  Assuming you don't...

That's what the tequila's for: it disinfects AND takes the pain away....

Bravo!!!

Another reason to remember that just because the word INTELLIGENCE is in the title of the application running it doesn't mean that the report will be used intelligently.  Nothing more...

I do it all of the time  Too bad they don't track number of edits on individual posts - I'd be a "top poster...

In true consultant form - I'll answer a question with several questions:

• Are you looking for a specific "known issues" or are you asking for background info purposes?
• Are you using a .MDB...

I propose to amend the proposal from  my esteemed colleague from dkranch.net to be a  "tequila and lime" law.  I'd second that....

...What are you trying to integrate into?  I guess - what do you mean by "integrate into"?  Are you building a wrapper around QA, trying to improve/extend what QA does,...

(continuing with Lynn's thought process)...in which case that size you just identified becomes the <target size> in the DBCC SHRINKFILE statement. That way - you're not making the file shrink...

I can see why having the government involved is a scary thing, but in a de facto monopoly situation, governments are routinely involved.

I'm not a fan of a set schedule,...