I think it was something to do with the column types? I can't recall now...I'll see if I can find the msdn article.

Hi Sarah,

Not sure of the answer myself, but I had a little dig around and found this link which may be of use to you.

http://blogs.msdn.com/sqltips/archive/2008/07/02/converting-from-hex-string-to-varbinary-and-vice-versa.aspx

Do you have any errors on any of the steps of the job? Expand the job history and post any errors/warnings you may see.

I stumbled across a blog a few days ago which directed me to a slide show by the chief data architect from MySpace.

Take a look at the slide show -...

Interesting. I'd read about BizTalk 2009. I didn't see anything about not being able to reorganize indexes.

I did read that you should not perform any online rebuilds and...

What Version of SQL?

1. Depends - table and index. It would be best to do it during maintenance in many cases.

3. There is downside to adding an...

The script will work.....

Before running it though, have ALL dates been entered in the same format? If not, then running the script won't fix the problem.

The script is good - I do the same thing myself.

Also, the 30% value you mention...Is this what the msdn article suggests? It could be a good starting place,...

Not that I know of. Only variables can be dynamic is a regular SQL query. If you want dynamic object names, you must wrap the statement with EXEC...

Hi Phil,

Not really sure I should answer considering you support Liverpool!! 😀

I've added a link which will be of use to you.

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Cheers

K. Brian Kelley (8/20/2009)

---

Have you applied at least SP2 to the machine running SQL Server Management Studio? This was introduced in that service pack as an extension to SSMS. You...

Are all 3 databases identical?

Or are the client databases a smaller replicated version of the server side database?

First step....Have a look through the logs to see if there is there any indication of why the database was marked as suspect.

Actually, I came across this posting a while...

Hi Mak,

Michael pointed out that the date was actually the table create...

So it is...Good spot 😀