The user loses permissions on the database when it is restored. The database user to SQL login mapping goes for a toss in many instances... Check if that is the...

The case of upper management not knowing who needs what access in SQL Server should not be the case in the first place. In most large organizations, that task falls...

Adding to Pradeep's reply above, I'm including the path you'd take in the SSMS.

1. Expand the Management node in SSMS and Rt. Click 'Database Mail'.

2. The Wizard opens up and...

eh.. that was the sp_helpdb <dbname> in the previous post..

my bad...

In case you need to figure out if the file was already created, or if you simply want to find the location of the ndf, then simply run the sp_help...