Is this a SQL login? Any chance it's just a mismatched SID issue?

In Management Studio make sure you're looking at the Database User, not the Server Login

or

SELECT o.[name], u.[name], p.permission_name

FROM sys.database_permissions p

INNER JOIN sys.objects o on p.major_id = o.object_id

INNER JOIN sys.sysusers u...

No, I don't believe that's expected. When you grant exec rights, it should show under the Securables for that User.

You can use 2005 Management Studio for 2008 databases, but you need SP3 and even then I've seen issues. IMO your best bet is to install the 2008 client...

Are you running perfmon or any kind of 3rd party solution to monitor the server? It's kind of hard to say without more info about what you're seeing on...

You can use xp_delete_file (http://sqlblog.com/blogs/andy_leonard/archive/2009/03/11/xp-delete-file.aspx) or you could write something using xp_cmdshell (assuming you have xp_cmdshell enabled).

I'm not sure I necessarily have a "solution" for your issues...

1. Yes, the summary pane defaults to List, but select a server or database and click on report and...

You can backup and restore dbs with developer edition. Actually the developer edition has identical functionality as enterprise edition, the only difference is in the licensing.

http://www.databasejournal.com/features/mssql/article.php/1438201

Thanks, the drop down is populating correctly, here's roughly what I'm using to populate with:

create procedure rpt_procname

@filter int

as

if @filter = 1

select

column1...

dtsrun/dtexec will take switches for username and password...

Thanks for the reply (although I don't see anything in your post). Should have replied earlier, but I figured out the solution last week.

How about a CASE statement?

Not sure how complex it will be, but yes a select is the best way to go.  If it's something you do a lot, create a view and select from...

You can also set up a new counter log in perfmon to send data directly to SQL.