Published
Monday, July 18, 2005 7:49 PM
by
robertvv
While experimenting with SQL 2005 I found out the following:
- SQL 2005 does not grant the user SA, DB Owner (DBO) role when a new database is created.
- When creating a SQL 2005 user account, the option "User must change password at next logon" is checked by default.
Save yourself some headaches and keep this in mind when using SQL 2005. Obviously the above points are good things, but I rather find these kind of "features/things" out the hard way. ;-)