If the database is SQL Server and they used native SQL Backups you should be able to do a normal restore. WHile .BAK is the default extension you aren't...

Can you post the full error?

I believe the key is at the database level so is not available in another database. You would need to do it all in DB1. I;d create a...

I think you want the datasets explorer window. Once you have a report open you can go to View on the menu and at the bottom is datasets.

If you do a refresh on the destination database in SSMS does the missing table appear? SSMS does not dynamically refresh when you add tables using script or an...

I think the closest counter to what you want in transactions per second.

You'd be surprised how many options there may be to do something when DDL and code is provided. Someone may have dealt with a similar issue and seeing code...

Please see the links in my signature to see how to post to get better answers. Without code and DDL there is almost no way anyone can give you...

Well, there might be a third party application out there that will do that, but SQL Server does not keep track of that as a role does not login a...

Have you compared the execution plans?

What version of SQL Server 2005 std, enterprise? There are differences in memory use in the 2. Is SQL Server using the memory...

Do you want to trace all activity for a specific database role? Profiler/Trace does not provide a way to filter by role. You could trace all activity for...

GilaMonster (12/11/2008)

---

Grant Fritchey (12/11/2008)

---

Got me...

Awesome! Thanks Brian.

I don't normally keep data down to the city table (I let the users have typos for city in addresses), but for countries and states/provinces I would only keep the...

Wow, guess I am lucky I have never (knock wood) been rear-ended.

Michael, you are probably right.

And that ties us back to the original thread topic - those people are probably...