Cross database access requires that the user also have rights in the other database.

Yes, if set to unrestricted growth, it will grow until it fills the drive. You should also look at setting tempdb to grow a set amount instead of 10%...

Obviously, your ERP database is using the Full Recovery model. In this model, if you are using Full, Differential, and Transaction Log backups appropriately, you can recover your database...

tymberwyld (11/10/2008)

---

Basically what's going on here is that someone is looking at some wireframes of the UI and that's getting translated directly into a database design. If they want...

GilaMonster (11/10/2008)

---

Seeing the code makes all the difference. It's not technically parameter sniffing.

That form of catch-all query does not perform well. Firstly the optimiser can't make accurate predictions with all...

CTE's aren't temporary tables. They are much more related to derived tables.

If you post in a SQL Server 2005...

Read BOL (Books On-Line), it will explain the different options available on the BACKUP command. If, after reading BOL, you still have questions, just ask.

Problem: Not enough information. We are guessing at what needs to be done to help you solve your problem. We need the whole story to be able to...

Lot of data, no information. What error are you getting?

You don't roll back. Do you have a current backup, prior to your erronous update? If so, you will need to restore it under a different name, and...

As long as what is written is the authors own work, why not? Each author has a different perspective on a topic and presents the information from that perspective....

I was looking at your a code a bit more, and it looks like it would still be used in a row by row fashion. What we really need...

The problem you have is that you can't use INSERT, UPDATE, or DELETE statements inside a user-defined function to update database objects (tables).

It is related to how the parens are used in the joins. Looks like the FROM clause needs to be rewritten.