Doug - I sure wish you had given this depth of information at the beginning - it tells exactly what you're looking to do. With the first post being vague,...

Probably not what you're looking for, but how's this?

Select top 5 'MY DATABASE TABLE: ' = name

from sysobjects

where xtype = 'u'

order by 1 desc

Add an Execute SQL Task to get the value from the database.

Put this value into a variable.

Add a For-Each Loop container.

Double-click the For-Each Loop container.

Click on the Collection tab.

In the...

Steve Jones - Editor (9/14/2010)

---

Well I sent a note to our BIT friend and got a reply back. Apparently

- he was abused

- I contributed to the abuser by pointing...

Yes, like that.

AND PM1.PM70.Projects.Project_Manager = (case when @PM is null then PM1.PM70.Projects.Project_Manager

else CHARINDEX( '~' + PM1.PM70.Projects.Project_Manager + '~', @PM) > 0)) end)

Okay, this looks like a where clause?

Lining it up...

If you're trying to find @PM in PM1.PM70.Projects.Project_Manager, then @PM needs to be the first parameter in CHARINDEX, not the second.

there are also:

dbo.sysmail_faileditems

dbo.sysmail_sentitems

dbo.sysmail_unsentitems

Umm... can you guess what they might be showing?

CREATE PROCEDURE DBO.GPM_SAFETY_INSPECTION_LOAD_INSPECTION(

@LOCATION VARCHAR(50),

@EMPLOYEE VARCHAR(50),

@DATE VARCHAR(10))

AS

DECLARE

@COUNT INT,

@QUARTER INT,

@MONTH INT

SELECT @MONTH = MONTH(GETDATE())

SET @QUARTER = DatePart(quarter, GetDate())

SELECT

@COUNT = COUNT(*)

FROM

GPM_SAFETY_INSPECTION

WHERE

SLOCATION...

GilaMonster (9/16/2010)

---

Actually no. In last 5 years I've had:

- One database with corrupt log that required a restore

- One very long restart/recovery (12 hours)...

Craig Farrell (9/16/2010)

---

WayneS (9/16/2010)

---

You know, I feel for both Gail and the OP here. I think the OP is under a lot of pressure and getting desperate to fix it....

if you want to do this at run-time, you'll need to add a parameter (@Proc_ID int), and when calling the procedure pass in @@PROCID.

You can then

select object_name(@Proc_ID)

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Here's one way to accomplish this:

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it...

Yes, it sure would! (just not as convenient as personally knowing it...)

What are the sizes of your user database files (mdf, ldf)?

Depending on the size, some of the earlier suggestions may not help much. And, depending on the size, they may...