Lynn Pettis (11/12/2012)

---

Steve Jones - SSC Editor (11/12/2012)

---

My luck that Bowe won't get me 2 pts tonight. Probably pop a hammy on the first play, where he'll catch a 10...

Looking at this:

ALTER PROCEDURE [dbo].[procDBMailInsertAndSendEmail]

-- Add the parameters for the stored procedure here

@datetimesent datetime = GETUTCDATE,

Remove the @datetimesent parameter. You aren't even using it in your procedure. ...

Steve Jones - SSC Editor (11/12/2012)

---

My luck that Bowe won't get me 2 pts tonight. Probably pop a hammy on the first play, where he'll catch a 10 yard pass...

Brandie Tarvin (11/9/2012)

---

There...

vs.satheesh (11/8/2012)

---

Hi

In my requirement

For example,

From date : 01-01-2012

To date : 30-12-2012

Intervel : 2 or 3 or...

Really can't help you based on what you have posted as there is simply not enough information. We can't see what you see from here.

Please take the time to...

It all comes down to Monday Night Football to determine the standings after week 9. If I hold on to win tomorrow I will still be in 7th position....

What were you doing when you received this error? Have you checked the error logs on both systems to determine if they could provide you with additional information, and...

It would also help if we could see the DDL (CREATE TABLE statement) for the table involved.

I have to agree, we really need to have the DDL (CREATE TABLE statements )for the tables, some sample data (INSERT INTO statements) for each of the tables, expected results.

Looking...

Duplicate post, please post any responses here.

Depending on your DR/HA requirements, you could also look at using the filestream to store the files, sice it looks like you are using SQL Server 2008 based on the...

Can you add additional disks to your server? I would highly recommend moving tempdb to its own drive, and preferably a large one just in case.

If this has been...

Added Scott's sample data to the mix:

/****** Object: UserDefinedFunction [dbo].[fn_datediff] Script Date: 10/30/2012 00:05:42 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_datediff]') AND...

Are we looking for something like this?

/****** Object: UserDefinedFunction [dbo].[fn_datediff] Script Date: 10/30/2012 00:05:42 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_datediff]') AND...