Oops, reread your question, I guess, you already know this article

Yes, there is actually an article in BOL that might help here:

Search for "error logs"->"severity levels".

David, wtf are you doing online here at almost a quarter past ten in the evenings???

I thought I am the only European who...

No! I really don't think so!

I think people join such groups in order to get entertained, educated and things like that for *free*. They only want to consume passively. No community...

John,

for your future postings here, please refrain from posting the same question in multiple fora. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=157096

Most members follow all fora, so there is no need for it. It actually...

A virtual friend of mine, SQL Server MVP Erland Sommarskog, has dedicated a separate chapter on the use of dynamic SQL and cursors here http://www.sommarskog.se/dynamic_sql.html

See if that is what you...

Just to add to Remi:

Read http://www.sommarskog.se/dynamic_sql.html . Erland's (he is one of the very few knowledgeable SQL Server MVP's IMHO) message should be very clear. Avoid dynamic SQL whereever you...

See if this helps:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

Don't know if this applies:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838840

If not, maybe you want to search my site for "analysis". Should return 31 hits back to KB, MSDN and TechNet. Maybe it helps a...

See if this helps:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

If I understand you right, see if this helps:

http://www.davidpenton.com/testsite/scratch/adodb.command3.asp

Nicolas, if you could post a script that will create a trigger on sysobjects, that would be very good of you. AFAIK, it is not possible to create such a trigger...

I never experienced any problems getting books, mags, training or whatsoever. I am pretty much a profit center of my own, meaning I am responsible for the costs I produce. I...

See if this helps: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=156835

USE tempdb

CREATE TABLE #t

(

 c1 VARCHAR DEFAULT ''

)

INSERT INTO #t DEFAULT VALUES

SELECT * FROM #t

DROP TABLE #t

works for me. However, I think you're doing this with EM. In that case, you...