Date20/11/2008 13:22:49

LogDatabase Mail (Database Mail Log)

Log ID2820

Process ID7492

Mail Item ID2701

Last Modified20/11/2008 13:22:49

Last Modified Bysa

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail...

Yes I was aware that MS purchased 4.2 off Sybase and rebranded as SQL

The server has a static IP and port specific for its own SQL Server. We have a number of web boxes and other servers which hook into the databases.

It...

The /PAE and /3GB stay in the boot.ini file yes.

The server still shows 16 in the lowest value for max server memory but the maximum shoots back up to the...

I would of thought that the changes would have to be done to each instance of SQL, with that in mind I would have to change AWE Enabled and Max...

Just on another note also to do with memory, if we where to throw the full 64GB of memory to the server, would we have to increase to 64 bit...

Sorry should of also included that the OS is Win Srv 2003 Ent and SQL is 2005 Ent.

Thanks

Anthony

Guys

Created a SPROC usp_InsertEpisode to which I will pass values, seems to work, but any tweaks you can think of

CREATE PROCEDURE usp_InsertEpisode

(

@TVShowIDINT,

@Episode_NameVARCHAR(100),

@seasonINT,

@Episode_NumberTINYINT

)

AS

BEGIN

DECLARE @CurrentSeason INT

SET @CurrentSeason = ISNULL((

SELECT Current_Season...