Are you restoring a full backup with norecovery before trying to restore the differential backup? A differential backup can't be restored by itself. See RESTORE in BooksOnLine.

Please give us more information about what you want. Do you want non-sysadmins to execute SSIS packages in SSMS? Do you want clients without SSMS to be able...

Choose a data source based on what created the .dbf file (dbase, Foxpro,?). If you can't find one in the list, you might be able to find an ODBC...

Jeffrey Williams (11/17/2008)

---

In SQL Server 2005 and greater, there is a default trace that is enabled. You can search the default trace for the creation, alter or deletion of...

Try removing "WITH REPLACE" from the differential restore statement. I think you only need that on the full restore.

That's one way to determine when the incident occurred. If you have some sort of auditing in place or have a DDL trigger that records when a table is...

Can you be specific about what didn't work? Did you make the user a member of the db_owner role in the database?

Sorry, that's all I have at the moment. I know sp_helpsrvrrolemember will give you server role membership info.

This script might suit your needs. It only works in SQL 2000.

This is a good article with examples. It helped me when I was trying to figure out how to do this.

http://www.sqldts.com/234.aspx

When you create a new job, you add steps to it. When you click on 'new step', you'll have the option to make the step type 'SQL Server Integration...

Actually sp_help_revlogin works for SQL 2005 also. There's a section in the kb article I mentioned that has a link to another article that has the text of the...

If you move a database by backing it up and restoring it, the users go with it. If you're moving databases to a different instance, you'll need to copy...

I don't think so. The request wants the database restored to the way it was on 10/31. Your method will restore it to the way it was on...

The license for Developer Edition allows one developer to use the software on any number of machines, but you'll have to buy additional licenses if more than one developer will...