Did you check the permissions of the user that runs the SQL Server? If it does not have appropriate rights then that kind of problem may occur.

Alternetively, you may try to have an inner select where you need the "text" field in your select and use a where clause like "where bacoDiscussions.Body IS NOT NULL AND...

You're welcome

Surely it works, but you need to do followings:

1. SQL Service must be running under an account (either NT or local)
2. This account must has at least one Outlook profile
3. When SQL starts...

CREATE TABLE Test
(
IDINT,
MtTextTEXT
)

Right click on the project go to "Properties" and then find "Configuration Properties" tab, under "Debugging" section unchech "SQL Server Debugging".

Hope this helps.

Cheers.

Hi Michelle!

If you use QA you will probably have ran the pieces of scripts in bunches that is in seperate runs. This way makes the transaction smaller. If your job...

or just group by col5

Switch to SQL 2005  It has DDL triggers that you can use to log alter statements so the sp versions.

Cheers.

then use text or ntext

I can strongly suggest you MS MOM utility. http://www.microsoft.com/mom/default.mspx

It can notify you for failed jobs as well as any other error you may want to be notified. (Hardware errors,...

May God help you

I too hate hate that kind of bosses who do not know what you are dialing with all the...

With which security account that the server runs? I mean if the sql server service runs with a different account than yours or the the system account that may not...

Isn't you trace files sequential? otherwise you will have to make recursive operation like that:

DECLARE @i INT
SET @i = 0

WHILE @i < 20 -- for example
BEGIN

INSERT INTO TraceMon (<Column Names&gt 

Making the "or" query into a dynamic statement is a good idea for this case but you should always keep in mind that the optimiser will have to optimise your query...