Andrew

If you're going to upgrade to SQL Server 2008 straight away, then just get your servers to a position where they can be upgraded. If that's SP4, then just...

Please don't type in capitals - some people interpret that as shouting.

Actually, the...

Does it work? If it doesn't, it's not right. After the collation name is the bit you need to pay attention to. And don't forget to change...

Does either one work? That's usually a good test. I don't think they will, since the error message you were getting related to...

Again, the answer is in the error message. Just put a column alias after the collation name in each SELECT statement, the same way I did for the "DBName"...

Probably because your databases don't all have the same collation. Choose a collation that will make all the database names distinct, and specify it in every SELECT statement in...

Surely you don't need me to explain this to you? Read the error message. There's no such object as DB1.sys.principals. Why? Because there's no such database...

WITH Users AS (

SELECT 'DB1' DBName, [name] FROM DB1.sys.database_principals UNION ALL

SELECT 'DB2' DBName, [name] FROM DB2.sys.database_principals UNION ALL

SELECT 'DB3' DBName, [name] FROM DB3.sys.database_principals UNION ALL

SELECT 'DB4' DBName, [name] FROM DB4.sys.database_principals...

You could create a trigger on every table that you wish to protect in this way. The trigger would roll back the transaction if the deleted rows were more...

I'm sure the search engine you use is as good as the one that I do.

Is there...

I'm sure if you really thought about it, you'd be able to answer that for yourself. Depends whether you want to find the text anywhere in the column's value...

I would strongly advise running your SQL Server services under a domain account. I don't know whether it's possible to grant access to Network Service on a remote computer,...

Yes. Use INFORMATION_SCHEMA.COLUMNS to find out which columns hold character data, and then build some dynamic SQL to search in all of those columns. Beware! Performance will...

Yes, sysjobhistory can help. You can interrogate it to find out which jobs have run and when, which...

Sri

I think you may be confusing primary key and clustered index here. When choosing a primary key, if one column uniquely identifies rows in the table, choose that. ...