1.to modify Default FG from primary to new FG, I would create nw FG, add new .ndf file, use ALTER DATABASE and make it default

2.to delete the new FG, make...

All,

I misquoted. I 'm gonna change default FG from Primary to new FG.

3. If the deleting filegroup is set as DEFAULT, then how to delete it and what would be...

David,

Its side by side upgrade. I used the Rev Login script from MSDN which scripts out the logins and password. It does not disable login/user by default.

I ran the script,...

After moving to 2008 from 2005, getting below error for sql logins.

Message

Login failed for user 'XXXX'. Reason: Password did not match that for the login provided.

Message

Error: 18456, Severity: 14,...

No one faced this error 🙁

Any worthful idea which can be tried out?

Ran your query Lowell. I didnt get "Login Exists but wrong sid: remap!" for any login. For half of the logins, i got NULL, dont know what that means.

I checked...

Error: 18456, Severity: 14, State: 5.

The login ZZZZ exists and it is linked to the user in the db. Still we get the error

>>> Login failed for user 'ZZZZ'....

What could be the reason for the below messge?

SQL auth is enabled, Login, user, db access are all provided.

Login failed for user 'ZZZZ'. Reason: Could not find a login matching...

Thanks Sibbald for the quick responses. Will get back if i still get any doubts.

Another query: http://support.microsoft.com/kb/246133

gives the 2 Stored procedure for generation of login script. But its for SQL 2000. Rev login SP has an additional code to add user to...

Amazing Script Sibbald.

Using query 1 and 2, i got the script to add an user to a server role. Is it necessary to run the 3rd query - 'Grant Connect'...

Some logins been added to some server roles (bulkadmin, dbcreator etc). After running login script, user-login gets mapped and has the necessary access to db's(read, write etc) as it is...

The roles would also be copied/set after running the script in destination? since there wont be orphaned users, the login would hav access as it was in source server, eg:...

These arent interview questions. While reading about blackbox trace, default/blackbox were used interchangebly which led to the confusion.

Yes. No Testing is sure way to go down. There would be a battery of testing before the final move.