The linked server approach assumes that the two servers can see each other. The example given shows no security info, so it is also assuming they are in the same...

I think he's comparing the backup times to/from tape for LightSpeed and TDPSQL to the native backup times to/from disk.  I also wish there was a product that would make...

You can't make any changes to the log-shipped database, so there's no way for you to add users or modify permissions.

You have to sync the SIDs for the logins between...

Try using the full UNC path for the package.  The current drive and current directory for the command window is not necessarily the same as the settings used by sp_OAMethod.

It...

I'm still not sure what you're looking for, but if you're talking about actual read/write activity during a query you could try the Windows performance monitor and trace reads/sec, writes/sec,...

At a Microsoft Launch event I learned that the in-place upgrade has a remote possibility of failing partway through, at a point when SQL 2000 is broken and SQL 2005...

Are the SIDs for the logins the same on both servers?  The standby database may have different security IDs for logins with the same name, so the users are not...

The default location for database files will be different (under the install folders, under C:\Program Files), but hopefully someone has had the sense to move them somewhere else.  Whether separate...

Almost nothing has been removed from T-SQL in general, except for system tables that are now dynamic management views, and some DBCC commands.  For example, DBCC DBREINDEX is now ALTER...

Doing a direct update to syscomments will probably work, but ...

There's a miniscule chance that the pattern you're searching for will be missed because it is split across two records. ...

Not quite.  To skip columns in the input file, use the number of columns to skip as the length and zero for the output field ordinal.

1  SQLCHAR  0  4  "" ...

Use CONVERT to format a date field for reporting.

CONVERT

(varchar, GETDATE(),1): 03/22/06

CONVERT(varchar, GETDATE(),2): 06.03.22

CONVERT(varchar,...

I don't know how you'd do it in Notepad, but I'm a big fan of TextPad because of its regular expression and multi-line replacement capability.  In TextPad the replacement would be:

Find:     ...

Creating large datasets gives you great performance as long as you only have one user at a time. 

Try to estimate the maximum number of concurrent users, and the size...

Under "Business Intelligence Projects" choose the Integration Services Project template.