Ryan,

How much activity are you expecting on this server? How many user connections? You're asking advice on RAID config for performance, but you tend to stability is also important. That...

Hi,

As promised: the stored procs I was telling you about.

Instructions:

1.You need to place the 'usp_KillDatabaseConnections' on each server you like to restore to.

2. Place the 'usp_restoreDBAsTestDB_Version_1_8 on the...

Hi Philip!

I Agree with Max and Brian! That's a hell of a job you did there! I really hope you publish this on SSC.

JP

Hi Philip,

Tough one for you.

Maybe Active Directory can come to your rescue. There's an attribute named SIDHistory in Win2003. If this attribute of your new useraccount can be filled...

Hi,

I have written a few USP's that do that job for me on a weekly basis. I will have to rewrite these USP's for you to get rid of 'company...

Hi,

Just another possible problem: I have noticed performance issues on production servers having more CPU's than test machines. It seems that the degree of parallelism / hyperthreading can have a...

Hi,

You need to monitor only SQL servers, or any kind of server?

JP

Hi

declare @my_dynamic_query varchar(8000)

set @my_dynamic_query = 'select [' + @column_name + ']

INTO ##ResultsTable

from [' + @table_name + ']

where [' + @column_name + '] = 23'

sp_executesql @my_dynamic_query

select @myVar = columname from...

Hi,

Difficult proces to restore the system db's.

I you're using Windows 2003 then you can always get a copy of the MDF and LDF system database files (using VSS/shadow copies)....

Wim,

You run a DTS Package, right? You can turn on DTS Logging and then check if the package runs in first place. (Or change the DTS Package, add a step...

Hi Jayakumar,

First of all:

Check your DB with the DBCC checkdb command. If the database is OK, then you can check on MS Support site for the error. The one you...

Hi,

Difficult problem. We had the same issue. The code is not HTML but RTF. Solution:

1. use this component:

REGEX (http://www.codeproject.com/managedcpp/xpregex.asp) and use this syntax to get rid of RTF: