For adding multiple db role to user, use procedure as

sp_addrolemember @rolename,@membername

Eg.

sp_addrolemember 'db_datawriter','membername'

Sachin Bhaygude

The db_papoulias_gr is DB name.

I am using sql server 2000.

I tried as,

exec sp_attach_single_file_db @dbname = 'db_papoulias_gr',

@physname = 'C:\Program Files\Microsoft SQL Server\MSSQL\data\db_papoulias_gr_data.mdf'

I had following error :

" Could not open new database...

You can use the combination of sp_ msforeachdb and sp_spaceused.

means

sp_foeeachdb sp_spaceused.

This will show u all database size and unallocated size.

Following SP alos help u to find out DB size.

sp_helpdb,

sp_helpfile

Sachin Bhaygude