Select Id, Col2, YourCol from dbo.YourTable where YourCol NOT IN ('ST', 'SV', 'SU') order by ??

What Dylan said .

I might add that this is most often used for "complex" search forms where any number of parameters can be entered.

This command is your new best friend

DBCC UPDATEUSAGE (DbName)

Then refresh the data displayed in EM (you MUST manually hit a refresh button for...

Is this related to this question or is this a new question all together?

I would go as far as saying that the queries reading from syscomments would make the app fail right there, but that's another story...

I'm sorry to say that I forgot most of the messages I posted over the years... only the logic and knowledge remains.  But I do remember quite a few new...

remove j.name like 'myjobnamepart%'

and try setting days ago to 1 or 14

Probabely means that the log file was full and that after 30 seconds, the resize still wasn't finished.

As suggested, try manually setting a bigger size (like the maximum needed size...

It makes the concatenation work easier. You don't have to check if a condition has been set before adding another conidtion dynamically. Query wise, that condition is checked...

Or you can create a 2nd column called version.  Update the name and the version with and update query, then manually update the rows such as photoshop.  Then update the application...

I don't mind for a single script.  But it was hard to figure out the difference when they were not side by side .

I'm glad to informa you that Microsoft already thaught of that problem.  If the text size goes beyong 4000 characters, a new row is inserted in SysComments to make sure...

I'll add to that that you may be able to merge some updates together so that you don't update for exemple, the same table with 4 statements, but only with...

So your boss wants you to redesign sql server. I think your time would be better spent doing something else... something doable and usefull.

Also this would definitly void any further support...

Ok that was too easy for you guys .