What is the frequency of your backups, copies and restores?

Simply do a string concatination on the existing version value.

update vehicle set version = version + ' BT' where unitnr = '140'

Ok then "Ensure SQL is Stopped" as the first step.

And yes SQL will start if TempDB is corrupt as it is recreated every time SQL re-starts.

Your question was on what...

1. Stop SQL, replace the fault disks which make up the F drive, once all ok start SQL

2. Stop SQL, start SQL in Master only mode, alter the file locations...

There are limitations with SSRS 2008, it still uses the old Excel structure so your limited to 65535 (approx) rows and 256 columns, if you want more columns you will...

Something some where is trying to put a value like ABC into a column which will only take a value like 123.

With such a large procedure, take it a chunk...

ccappel (8/31/2012)

---

Thank you for this thread...I have been dealing with this problem for years without resolution. Just to make sure I understand the gist of the problem:

1. The...

Yep, you plan is right in theory.

You would pass in a sql file to SQLCMD using the -i switch and then wrap the whole SQLCMD call into a bat file...

A repair didnt work, failed with an error saying the services didnt install properly so had to do an uninstall re-install.

Reading further into the error, it seems like it was...

You will need to alter every column in every table to match the new collation, then alter every table, then alter the database

Or

Create a new DB with the right collation,...

Well your violating the licence terms of the evaluation edition running it in a truly production environment, it should be licenced accordingly.

Evaluation is to ensure that the software will do...

Something is activly using the log then.

The first link on why is my transaction log full should help to find out what is using so much log space.

These should provide some good reading on the topic of TX log management

Why is my transaction log full - http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

Managing Transaction Logs - http://www.sqlservercentral.com/articles/Administration/64582/

Stairway to Transaction Log Management - http://www.sqlservercentral.com/stairway/73776/

Accidental...

Maybe this will help http://www.microsoft.com/en-us/download/details.aspx?id=22052

You should only put people in System Administrators / System Users who you want to have elevated rights to SSRS.

System users description

View system properties, shared schedules, and allow use of...