| Author |
 Topic  |
|
|
esthera
Flowing Fount of Yak Knowledge
1410 Posts |
|
|
russell
Pyro-ma-ni-yak
USA
5072 Posts |
 Posted - 04/05/2013 : 10:15:07
|
Giving Tara's script a quick once over, I'd say modify this line:
IF @version NOT IN ('8', '9')
to
IF @version NOT IN ('8', '9', '10')
then go find all the IF blocks and add '10' to everything that says '9', for example, this line
ELSE IF @edition = 3 AND @version = '9'
becomes
ELSE IF @edition = 3 AND @version in ('9', '10')
That's just with a quick glance, so it may ot be complete, but pretty sure that'll work.
|
 |
|
|
russell
Pyro-ma-ni-yak
USA
5072 Posts |
Posted - 04/05/2013 : 10:18:24
|
Actually, that would be 11, not 10.
And change this:
SET @version = CONVERT(char(1), SERVERPROPERTY('ProductVersion'))
To this
SET @version = CONVERT(varchar(2), SERVERPROPERTY('ProductVersion'))
Might be more but that looks about right |
|
|
| |
Topic |
|
|
|
best backup routine on 2012