We have test and production only.

Very handy script thanks!

I did add the following: serverproperty('productlevel')ServicePack,

after the line: end as VersionName,

Since I can't remember what service pack my sql servers are on 🙂

Great script, Thanks!

Ken

I'd be a 1970 Dodge Challenger, similar to the one in the movie Vanishing Point.

Currently dirve 2002 Grand Prix GTP and if the weather is real nice my '68 Firebird

Excellent article, as an Oracle DBA who is responsible for both Oracle and SQL Server databases it is nice to see a side by side comparison of the two systems...

Spend more time with the family, go back to school to study music and recently found a college which offers a BA degree in auto restoration; how cool is that?!

Excellent Script! Thanks!

Gail,

That was it!! Guess there really is something to 'another set of eyes'! Thanks so much!

Ken 🙂

I would say I spend about 25% of my time as 'self directed'. I suspect I could have more time but I am the only DBA here administering many SQL...

I would say I am not better pay wise but I do have a job! I to work for a local government and for the past few years we have...

Where I currently work I wear multiple DBA hats; I serve as both Oracle and SQL Server DBA, I pick and train my backup. I believe the problem stems from...

We were running this as SA, in an effort to eliminate permissions issues. I did find something new, in the code the bolded statement makes a reference to a table...

thanks for the reply,

The collation is: SQL_Latin1_General_CP1_CI_AS

I will have to look for a case issue...

Well don't know but I have always found keeping a healthy level of insanity helps keep me sane dealing with this job at times!

Ken

Ok thanks Jeff!