Thanks that makes a lot of sense. Even thought the column is varbinary(max) the data is still stored on the file system and not in the data file, so it...

Thanks for the reply Gila, it helps a lot..Just one more think I am curious about, would I always use varbinary(max) or would I be able to use for example...

So that means that it will do half of the work, commit it, and then rollback the second half? In my scenario there are no explicit transactions.

Hi Gila thanks for the advise..Yes will would have removed it in a test environment first not on production. Do you know of any sites where I can learn about...

Thanks for the feedback on this, it is very helpful. I am actually assessing Indexes on a production environment and the one tables that is always involved in deadlocks has...

Hi Guys thanks for the replies it was very helpful. Just one more thing, If say I have a clustered index on ProductID, and ProductID is the first column in...

Thanks for all the feedback guys, I will keep this in mind.

Hi Guys,

Thanks for the feedback. There is no reason I has to be done by restoring the msdb. I just thought I might be faster than scripting out every single...

I have now reinstalled SQL and it solved the problem. This is not the solution that I was hoping for but unfortunately I was running out of time so I...

No I am running a Standard Edition.. I have also tried the link provided but I get the same errors in the cmd as in the log file. Thanks for...

I ran the repair and it did not fix the issue. The Database Engine Services, Data Quality Services, Full-Text and Semantic Extractions for Search and the SQL Server Replication...

I have tried using cmd but I got an error, can't remember what, will check and post. If I repair it using the setup, which folder do I point it...

No I cannot even start it with a domain account. This is just the DR server, we don't have a DR solution in place any more.

The SPN is the last...

Hi guys,

No I have not yet checked with the domain admins. I have dealt with something like this before. This server use to be the live database server, then it...

Thanks for the tips, I will do some research on these.