I've played guitar for about 10 years, loved playing blues, classic rock, classical, shred. I used to concentrate on my chops and improv and learning Steve Vai tunes.

I'm also into...

Unless you trace for specific events or setup triggers, the only thing that I can think of that may be of use is the sys.dm_db_index_usage_stats system view. This will show...

Tablediff is also useful for these sorts of things and can even generate scripts to fix differences between tables.

http://msdn.microsoft.com/en-us/library/ms162843.aspx

Do you use Veritas Backup Exec?

GO only works in Enterprise Manager, the SQL Engine doesn't know what it is.

DECLARE @newline AS NVARCHAR(2);

SET @newline = '\CR'--CHAR(13) + CHAR(10);

DECLARE @sql NVARCHAR(MAX)

SET @sql = '

USE...

You generally don't want to shrink the log file, if it's growing to 100GB regularly after being shrunk, then you want to make more space available for it. Every time...

Fantastic idea, thanks.

Yes, you don't need to keep telling them what you can't do. You should be emphasising what you can do and when it comes to doing the tasks that you've...

^Yes, I think you can create a snapshot of the mirror, but only if you've got Enterprise edition.

Sorry, as Steveb said!

Mirroring would only create a secondary database that's "in recovery" mode, so you won't be able to access it. I think you should look into replication.

http://msdn.microsoft.com/en-us/library/ms151198.aspx

It says that you can't connect to the version of SQL Server with your management studio and you need a newer version.

To test if you have connectivity from your workstation,...

Nope, need to upgrade SSMS in order to be able to connect to SS08.

A custom shortcut I tend to use quite often:

Go to Tools > Options. Expand Environment > Keyboard.

Set Ctrl+3 to SELECT * FROM

Set Ctrl+4 to SELECT TOP 10 * FROM

Click OK.

Once...

You could always union the same statement for each database.

SELECT *

FROM DB1.sys.sysobjects

UNION

SELECT *

FROM DB2.sys.sysobjects