I see what you mean. It seems to do that if you're importing to an existing table whether or not it has the same structure as the source table....

This is one of my gripes about SSMS. Object were are lot easier to see in Enterprise Manager. About the only way to make granting permissions quicker is...

Is the check box for dropping and recreating the table greyed out when you edit mappings or do you get an error when you execute?

I agree with John and Chris about not changing the database to simple recovery mode. You say that the database is very heavily used. I'd recommend doing log...

Nvarchar, nchar, and ntext are unicode datatypes that are designed to cover all the characters of all languages, so they should be used in databases that are used internationally, particularly...

This doesn't appear to be a SQL 2008 question, but since nobody has responded...

The only way to search for a string in a job is to script it out and...

I think she must be a member of one of the Windows groups. If she can see the contents of a database, it's because that group is a member...

Brandie,

Ed is right about adding role members. A role or user inherits the permissions of the role that it's a member of.

When you double-click on a database...

If you have an SA account, then mixed mode was selected during installation. Which mode you choose depends on your environment and your security requirements. Mircosoft recommends using...

Yes. If someone hasn't been granted permission to connect to SQL Server i.e. they're login hasn't been added to the SQL Server, they can't see anything. You wouldn't...

Can you be more specific about what doesn't look right?

I don't get it. I tried both methods and both allowed the user to see SQL Server Agent. Oh well, as long as it works, eh?

BTW, I think...

This script might help you: http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31995/

Well, that's strange. So, you first tried creating your own database role in msdb? Would you list the permissions or role membership you assigned to it, so I'm...

I think it would be possible with a log reader tool. We use Lumigent Log Explorer and it can read a backup of a transaction log without having to...