The thing that always irked me thou with the built in FTP component is how poorly it performs. I deal with very larg files sometimes and with http://ftp.exe and...

I see this. When I tested wrote and tested this I am fairly sure I used QA (not sure if was 7 or 2000 thou) and against multiple 7 instances but...

From everything I recall and have read there is no such need in the 64bit environment and SQL should have no problems with using the memory.

This however will provide a...

Just purchased a 64bit intel processor and plan to test SQL on it to see if I can tell a difference. But other than memory support I don't see much...

Also you might want to consider setting up a seperate filegroup for text data as oppossed to your primary filegroup. In SQL 7 there were known issues with recovery of...

In addition the SELECT generates a recordset whereas PRINT returns to the message buffer.

That would have to be in your Stored Procedure. And IsNull will rely on data actually being returned. Could you post what the output looks like for the data and...

Without assuming anything if this code is for a stored procedure consider using multiple procdures with one deciding the logic.

 CREATE PROC dbo.GetDataProc

  @DateSubmitted as datetime = null

 AS

 SET NOCOUNT ON

 If @DateSubmitted IS...

To clairfy the previous this should do it.

SELECT

 P.PERINDEX,

 SUM(CASE

  WHEN

   BKI.RexType = 'R' AND

   bki.mrwid != 'R' AND 

   bki.mrwid NOT LIKE 'R[0-2]%'

  THEN

   BKI.BkiNumber

  ELSE

   0

  END)

FROM X, etc etc

Hope your manager has a charge back policy if your groups budget seperately. The way it works for use if a restore has to be done it is anywhere from...

May not be that simple. You say using that view, is dbo.plt a view? And if so are the indexes for subscriber_no and ban on the index or underlying tables.

Can...

No. The code can do Select, Update, Delete and Insert against tables and views and EXEC against other SPs or utilize user defined functions without granting permissions. That is unless you...

Not sure they couldn't. You have to look at the companies busness model and trim any unneccessary items to be 100% sure. But in the short term they will not...

I am just going to throw this one to the wind for fun.

Let them choose to do as they please becuase ultimately if they screw the system the system will...

If it is a standard table then no. But if it is a temporary table prefixed with eiher # or ## then yes.