I am running several SQL Server 2005 Instances (SP3with CU4) on a Windows 2008R2 Platform.
After I installed the instances I moved the System Databases to a drive other than their original install location and then I must have applied the service packs after I moved the databases so I ended up with 2 sets of the mssqlsystemresource.ldf and mssqlsystemresource.mdf files.
I have since realized that moving the system databases (master, msdb and model) from their original locations is not good practice so I will be moving them back. the model and msdb will not be a problem to move but my dilema lies with the master DB and the 2 sets of mssqlsystemresource.ldf andmssqlsystemresource.mdf files.
Is there a way to tell either by some query or through searching the registry to find out which set of mssqlsystemresource files to keep?
I have one set here \\kocsql05\e$\Microsoft SQL Server\MSSQL.3\MSSQL\Data dated 10\15\2011 (which is the original install directory)
and one set here: \\kocsql05\f$\MSSQL\KOCSQL05\Sharepoint\Datafiles dated 9\26\2009 (which is where I moved the master.mdf file to)
I'm ASSUMING that I should keep the newest mssqlsystemresource files (in the original install location) but I am not sure. any thoughts on how to rectify this and get the master database files back into the original install location with the correct mssqlsystemresource files ????
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …