Apologies my mistake, I mis-read the article to imply that SQL always got a new port with dynamic allocation on restart.

One comment - 'Dynamic Ports being the default for named instances'. The port is only truly dynamic for the installation of SQL Server - once it's installed, the port number...

There's an excellent blog by Kalen Delaney on this subject :- http://sqlblog.com/blogs/kalen_delaney/archive/2007/09/13/geek-city-the-resource-database.aspx

I think her query from sysdbreg table does still show some ambiguity in the database name though...

Quoting from above..

"You can connect to the database under certain single-user mode conditions by typing the command USE MSSQLSystemResource..."

So, the question should have named the database correctly as MSSQLSystemResource.

We...

From a SQL Server Errorlog during startup :-

Starting up database 'mssqlsystemresource'.

The question is wrong - 'mssqlsystemresource' could be referred to as a system database, and I think there are arguments...

Is also in SQL Server errorlog - 4th line of log..

'Server process ID is xxxx.'

Franco,

sounds like you have only restored your first transaction log - ie your database is back to it's 11am state.

You need to change your restore log statement,...

Badly worded question I think. First errorlog I'd check after restart would be the current errorlog - to ensure SQL Server problems are resolved. Then I'd start worrying about the...

Schalk,

This is not a direct answer to your question - but have you considered sp_readerrorlog. Take a look at http://vyaskn.tripod.com/sp_readerrorlog_undocumented.htm 

for more details - it might be useful for you...

Sounds like you need to look at replication - have you considered transactional replication ?

Replication is quite a big topic - so I'd suggest you have a good look in...

You can use UNION to combine two queries - ie :-

SELECT STATUS, COUNT(STATUS) AS Expr1

FROM dbo.DOCUMENTS

WHERE (COPIES = 0)

GROUP BY STATUS

union all

SELECT STATUS, COUNT(STATUS) AS Expr1

FROM dbo.DOCUMENTS

WHERE (COPIES = 1)

GROUP...

Blank sa password only scores -10 ! Surely this should be -100 or instant dismissal

Developer having sa rights on dev server gets -12.

Surely...

Hmmm - not really a best practices list - more a new features description. 

Would a best practice be 'turn off CLR enabled' sp_configure option until ordered to turn on by senior...

I was just wondering if this research is relevant for the standard and enterprise editions if SQL 2005 as it was generated against the 2005 express edition beta. Are DBCC...

I think everyone would be aware of sp_who or sp_who2 - and know that these procedures query sysprocesses table 'behind the scenes'. So, in my opinion, this is a badly worded...