I would like to suggest that you read the first article I reference in my signature block regarding asking for assistance. It will walk you through the steps you...

It may help if you posted the entire error message not just parts of it.

May I suggest that you take some time to read about backups and restores in Books Online, the SQL Server Help System? If, after reading, you still have questions...

lmu92 (4/16/2010)

---

@dachen:

Did you notice that there were almost 50 people reading your post and actually moved on?

But as soon as there are ready to use sample data available, you already...

Here is an alternative solution:

DECLARE @tbl TABLE

(

Level1 INT,Level2 INT,Level2_ID INT, Status VARCHAR(10),Date DATETIME

)

INSERT INTO @tbl

SELECT 1234, 345, 222 ,'Active ','4/10/10' UNION ALL

SELECT 1234,...

mark.hammond (4/16/2010)

---

The absolute BEST reward I have ever received for hard work was an all-expense-paid trip for my family to Disney World. My boss even placed "gross it up"...

mark.pleasance (4/16/2010)

---

I work for a SMB beverage alcohol import agency . . .

As compensation we receive . . .

Competitive pay (reviewed ad-hoc,) flex time, work from home, health benefits,...

Luke L (4/16/2010)

---

Gianluca Sartori (4/16/2010)

---

Luke L (4/16/2010)

---

So is there a good way to search within a thread specific thread? Looking for information from earlier in this thread. Someone...

Anybody have some references that support setting the maximum memory setting for SQL Server 2005 x64?

Apparently, personal experience doesn't count.

Well, what they say and what really happens in the real world sometimes doesn't match. Having experienced the problem, I find it easier to prevent it than argue that...

Just another option:

select convert(char(6), dateadd(mm, 1, dateadd(mm, right(@Date, 2) - 1, dateadd(yy, cast(left(@Date,4) as int) - 1900, 0))), 112)

NJ-DBA (4/16/2010)

---

Would you agree with me that SQL Server shouldnt do that? there should be no requirement so set max server memory because as designed, sql server should yeild...

No links I can point you to, just experience with our move to x64 hardware. I failed to set maximum memory on one of the blades we installed SQL...

esto4273 (4/16/2010)

---

Sorry Lynn. I know you would like to see tried code, but I'm not aware of what is possible. guess I was wondering if someone ha da code sample...

george.greiner (4/16/2010)

---

Lynn Pettis (4/16/2010)

---

To begin with, this is really a business decision first. Once you have the requirements for doing the invoicing, then it should become easier to determine...