Transcript Bug Catcher 1

Bug Catcher 1
CREATE LOGIN James
WITH PASSWORD = 'A'
Answer: SQL 2005 and 2008 can
enforce the password policy of the
operating system.
CREATE LOGIN James
WITH PASSWORD = 'ABC$$123'
Bug Catcher 2
GRANT LOGIN James
WITH PASSWORD = 'ABC$$123'
Answer: You need to CREATE or ALTER a
login while setting a password.
CREATE LOGIN James
WITH PASSWORD = 'ABC$$123'
Bug Catcher 3
--You created the James login and are using the correct
password. Why can’t you log in?
Answer: Change Server Authentication mode to
SQL and Windows.
Bug Catcher 4
DROP LOGIN James
WITH PASSWORD = 'ABC$$123'
Answer: To drop a login you don’t need
to specify the password.
DROP LOGIN James
Bug Catcher 5
GRANT James CONTROL SERVER
Answer: Specify the permission after
the Grant DCL keyword.
GRANT CONTROL SERVER TO
James
Bug Catcher 6
FORBID ALTER ANY DATABASE TO
James
Answer: There is no FORBID keyword.
DENY ALTER ANY DATABASE TO
James