Steve, the package variable [User::ValidationFlag] is Int32 - which seems to not be too much of a problem.  What I have been told is Visual Studio 2015 and SQL Server...

Good article with a few insights:

/PAE does not do anything for a 64-bit Windows O/S.

http://msdn.microsoft.com/en-us/windows/hardware/gg487503

Also, the 32-bit address space limit is 4GB, not 2GB.

2^32 = 4294967295

AWE really helps...

Pradeep,

That is using a bigger hammer then I had planned, but it did work.

Sadly, Microsoft doesn't have a reasonable solution to this. Since the database had never really been...

sp_repldone does nothing - since the database is not replicated, it only generates an error.

If the answer was simple, I would not have spent the time posting.

Let's just say I...

Check/swap your fibre cable/switch port on the SAN that plug into this host. We were getting loads of temporary errors on one of our LUNs, only to discover the...

I have seen this message on servers where the disk I/O level was really high and where I had a drive that was failing.

Questions:

1) Is the Y: drive part of...

Hi,

Is there any reason that this T-SQL code will not work for you?

declare @Filename varchar(255),

@Servername varchar(255),

@Date varchar(10),

@FilePresent int

-- Variable @FilePresent = 1 if the file is found.

SELECT @Date = convert(varchar(10),getdate(),112),...

Hi,

If you are attempting to send email from your local server without having SMTP installed (sendmail client) you can use CDOSYS and VBScript.

Visit this web page, it covers a script...

You have to consider all platforms, this question does not.

The "correct" answer is not valid.

The official "Security note" from BOL is below:

Security Note:

SQL Mail is not installed by...