I don't think so, particularly in SQL Server 2005. Checking the Resource Governor in SQL Server 2008, it looks like you can only control CPU and memory resources. ...

Yep, I can do it without using a UNION.

I'm sorry, I don't see how we should help here. This is not that...

There is a difference, you have access to the database and the data, and to the SSIS package. This gives you a lot more info than we have, as...

I have some understanding of PeopleSoft has I help support the databases for our Finance and HR systems; as well as helping the PeopleSoft developers with SQL queries and tuning.

You...

No.

I'm right there with you.

Check out the db_ddladmin database role in BOL (Books Online) and see if this is what you need.

No problem, happens to us all at one time or another.

timscronin (12/14/2009)

---

Ok I am stumped, got dbmail to work however, when I wanted to add another name to the receipt line I get an error, can't find anything in BOL...

How about some sample data and what it should look like? In this case, you can show me what the parameters to the WHERE clause should be based on...

I am sure that there is a better way to do what you are asking. Problem is, I'm not exactly sure what you are trying to accomplish. Please...

First, you are saying you don't have any good backups of the database?

Second, what is the error(s) that took the full-text index offline?

Just guessing here, because you are running Activity Monitor and it accesses the server?

Pratap Prabhu (12/14/2009)

---

As mentioned its for parsing Parameters passed in to a stored proc. In a real world scenerio an app would let a user select multiple items in a...