Aren't the Tools (which includes the SSMS) in a different folder on the media than the SQL Engine install folder?

Yes, that's very odd. I confirmed with the other DBA here and he has also the Pre_release SSMS installed.... He's requesting the media from M$ now..

Strange thing is that I DID install all from an RTM disk. I have 1 SQL 2008 Server install with the Client tools, and the version for the engine is...

We mostly use "SQL_Latin1_General_CP1_CI_AS" but we have some applications that require different. It's really depending on the requirements of the application what you would have....

.. as John posted, you need to help us also to provide you help.

Read here Forum Etiquette: How to post data/code on a forum to get the best help[/url]

... you know you can Edit your own posts, right? 😎

... I must be missing something, but that query, in T-SQL would look different. First of all, STARTDATE would need to be a valid variable, ie @STARTDATE and then the...

The amount of memory SQL can use depends on the OS in use.

See this chart for comparison.

And here you can...

... probably Word97-2003 which share the same format....

In theory, the SA account should not be used by any process at all, only for sysadmin purposes..... but, as we all know that is not always the case.

...

As Gail mentioned above, the table does probably not have enough data to be "considered" for a reindex. I have a few tables with a couple hundred records that don't...

It could be because the Action is spelled wrong? You have there "autousefix_fix" and it should be "Auto_Fix" ?

I guess Lowell's post above give's you the best option, using the LEFT and charindex to find the opening < of the html tag

... I know.. I just wanted it to be as simple as possible for the OP 😉

kpid is numeric, so you should change that to:

+ 'WHERE kpid = 7116 '