check here this is an excellent place for patches and dates

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

-D

Thanks for the reply..much appreciated

How many databases per server...ranges from 15 - 60 on the conservative side. Well i want to allow the users to do what is needed(some...

is it xp_cmdshell enabled(???)... permissions(sysadmin) .... and i hope this answers the questions you asked. I do know that if i run the command directly in QA it gives...

Why not use perfmon or one of the tools already with the OS Server that would be much easier and give you a better running of whats going on. ...

A better way..who knows... currently the best way as we all will agree is the one that gives consistent results and works to your satisfaction with positive results...hehehe anyways.....

Hello there,

There is always going to be some extent of fragmentation when your database/tables grow (nature of the beast). But to watch your system that close is a GREAT idea...

look in scripts area to add more or find others.

-Darryl

So my question is this..if you have 64Bit MSSQL Ent Edition why would you need AWE if you are running with 64Bit Ent Edition OS. Considering that the Entprise...

Hey G 🙂

YOU ROCK!!!!!!!!!!! Thanks a ton for you input and super highly appreciated. The convert was spot on and wooo hooo cant say thanks enough. :w00t:

-Darryl

From experience with clusters and DR the one thing that easily forgotten in this is Backups. Because sometimes the thought process of the cluster/db's are mirrored or what ever,...

Thanks for the replies so far.. much appreciated. After looking closer into the table i did make the necessary changes that were mentioned...adding a useful index as well as...

hello,

i have worked on many clusters and i have found that the best solution in a case where the system databases have become corrupt is usually to rebuild. If...

Thanks for the cast input as it works wonderfully. But i have seen to come across another problem as well which i am sure is due to the fact...

OK thanks....did not know that as your comments did not specify versions...You have anything for older versions that return the same type of results?

hello .....wanted to use your script and having issues.. It complies perfectly but when its run this is the error i receive. This is running on MSSQL 8.00.2039....