SQL Server

Craig found an amusing dity today, he was messing around with the settings in SQL Server Express and noticed these memory settings: For those of you who don’t want to deliminate it, that’s: * 2,147,483,647 Megabytes * 2,147,483 Gigabytes * 2,147 Terabytes * Or 2 Petabytes!

Here's some code I regularly find useful when going from a dev server to a production server (or changing the username), I'm sure there's a more automated way but for a quick fix... DECLARE @username varchar(100)SET @username = 'xyz'SELECT'