I would think you'd be able to convert text to varchar(max) and do the replace operation on it.

Well, using CTE's (note today's article) I came up with this solution:

DECLARE @start_dateDATETIME

,@end_dateDATETIME

SELECT @start_date = '01/01/2007'

,@end_date = '02/13/2007';

WITHCTE_Dates(Monday) AS (

SELECTCASE

WHEN DATEPART(dw, @start_date) <= 2 THEN DATEADD(dd, 2 - DATEPART(dw, @start_date),...

master.dbo.xp_msver

It gathers its information from that procedure if I recall. It queries the actual values from the system... I don't believe they're stored anywhere in a table.

sp_msforeachdb 'select ''?'' as db_name, count(*) as table_count from ?.dbo.sysobjects where xtype = ''u'''

That should do it.

I believe you need to be db_owner because a database diagram has the ability to enact schema changes.

It depends...

I'd ask how large the data set you'll need to get is, how often you'll be accessing it (will you need to be referencing it often like you might...

Please don't spam the forums. If you have a concern with the way Red Gate handles their licensing there are better ways to handle it.

I'd definitely leave off the second one, the third one should cover anything needed by the second one.

More indexes = more work on any write actions (insert/update/delete), so pick what...

Shrinking and growing the log file increases the chances of file fragmentation on the drive. This can degrade I/O performance as the disk(s) have to seek more to locate...

A new database, vardecimal, is included

Datatype?

When I was at PASS I asked a MS rep about SP2 and they said "March or early April"... so mid-February doesn't seem so late...

Truncate statements require ALTER TABLE permissions.

Try the db_name() function?

I believe you can use a transfer logins task in DTS/SSIS to move the logins over. Then you probably would need to remap them to the database users with...

If Step is always incremented by 10 with no gaps, you could easily just outer join back to tblMpRequirements with something like "R.Step = R2.Step - 10" and join that...

In general this is not a good practice.

In reality, I've usually seen it because someone logged in, ran a quick script and THEN realized that their default database was...