Thursday, April 27, 2006
Thursday, April 20, 2006
The build number is 2047 (v. 9.00.2047).
Read the list of changes and fixes before attempting an upgrade.
I've installed the CTP when it was first made available, so I guess I'm looking at a uninstall/reinstall weekend. :)
Oh, yes - SQL Server 2005 Express and Express with Advanced Services have also been made available.
I'll have to start the weekend MTV-style - 8:00 AM Friday morning.
You may run into some difficulties when upgrading SQL Server Express to the Advanced Services Edition.
Thanks to Andrej Tozon (links) here are two links to help you out:
- How to upgrade from SQL Express to SQL Express Advanced;
- "Login failed for user ‘sa’" error when upgrading to SQL Server 2005 Express Edition with Advanced Services.
p.s. The registry key that needs to be empty prior to installing SQL Server:
Friday, April 14, 2006
create function dbo.fnExists_DDLTrigger ( @name sysname ) returns bit as begin declare @exists bit if (exists ( select * from sys.triggers where (sys.triggers.parent_class = 0) and (sys.triggers.[name] = @name) )) begin set @exists = 1 end else begin set @exists = 0 end return @exists end goML p.s.: You might also find this function usefull.