How to compare two versions of sqlserver?

HI,
I need to do an installer utility in which I have to install sql tables. In
there, I would need to check the version of sql server and add some
constraints if the sql server version is more than 8 and do alternate action
if its not.
Is there any function like version_compare()?
Thanks & Regards,
Celia
msnews wrote:
> HI,
> I need to do an installer utility in which I have to install sql tables. In
> there, I would need to check the version of sql server and add some
> constraints if the sql server version is more than 8 and do alternate action
> if its not.
> Is there any function like version_compare()?
> Thanks & Regards,
> Celia
>
>
There isn't a "out of the box" version compare function as such. I think
you'll have to use @.@.Version or SERVERPROPERTY and then use the result
you get from here to do your evaluation.
You can look up both options in Books On Line for further info and syntax.
Regards
Steen

How to compare two versions of sqlserver?

HI,
I need to do an installer utility in which I have to install sql tables. In
there, I would need to check the version of sql server and add some
constraints if the sql server version is more than 8 and do alternate action
if its not.
Is there any function like version_compare()?
Thanks & Regards,
Celiamsnews wrote:
> HI,
> I need to do an installer utility in which I have to install sql tables. I
n
> there, I would need to check the version of sql server and add some
> constraints if the sql server version is more than 8 and do alternate acti
on
> if its not.
> Is there any function like version_compare()?
> Thanks & Regards,
> Celia
>
>
There isn't a "out of the box" version compare function as such. I think
you'll have to use @.@.Version or SERVERPROPERTY and then use the result
you get from here to do your evaluation.
You can look up both options in Books On Line for further info and syntax.
Regards
Steen

How to compare two versions of sqlserver?

HI,
I need to do an installer utility in which I have to install sql tables. In
there, I would need to check the version of sql server and add some
constraints if the sql server version is more than 8 and do alternate action
if its not.
Is there any function like version_compare()?
Thanks & Regards,
Celiamsnews wrote:
> HI,
> I need to do an installer utility in which I have to install sql tables. In
> there, I would need to check the version of sql server and add some
> constraints if the sql server version is more than 8 and do alternate action
> if its not.
> Is there any function like version_compare()?
> Thanks & Regards,
> Celia
>
>
There isn't a "out of the box" version compare function as such. I think
you'll have to use @.@.Version or SERVERPROPERTY and then use the result
you get from here to do your evaluation.
You can look up both options in Books On Line for further info and syntax.
Regards
Steen

How to compact & repair database in SQL Server 2000?

Hi All,
You must be knowing that we can compact & repair database in
ACCESS. Is there any way / utility to do the same in SQL Server 2000? (Serve
r
CE does provide this facility)
Regards,
HarshadNo
But you can use DBCC CHECKDB to do consistency check.(which is done by
compact and repair wizard in access)
--
Regards
R.D
--Knowledge gets doubled when shared
"Harshad Phadnis" wrote:

> Hi All,
> You must be knowing that we can compact & repair database in
> ACCESS. Is there any way / utility to do the same in SQL Server 2000? (Ser
ver
> CE does provide this facility)
> Regards,
> Harshad|||As for defrag and compaction, I suggest you check out:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:F1864887-1CAD-4430-A59D-2ADAE4FBE487@.microsoft.com...
> No
> But you can use DBCC CHECKDB to do consistency check.(which is done by
> compact and repair wizard in access)
> --
> Regards
> R.D
> --Knowledge gets doubled when shared
>
> "Harshad Phadnis" wrote:
>