Thanks all for the reply.

Our Dev guys are referring to this document from Microsoft:

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc

But I agree. Our smtp server is secured with firewall so why not use the...

Thanks Guys

As far as usage is concerned, it will be used average 10-15 times and 30-40 times in a minute during peak if not more.

I believe app_name() should work...

Thanks guys for the feedback.

I agree that code review is the best thing as I myself just open up a new query and start typing 'Create procedure ..' I

I...

I second the opinion of the previous posts. I would simply download the trial version that is valid for 14 days and restore the backup using the tool. I have...

Excellent article. Cleared up all the questions/myths aboout temp tables /variables.

Thank you..

If possible, run 'dbcc showcontig' command for your table. Do this at off hours as it can affect performance.

Check for the scan density value.

If the fill factor is...

1,2,A,B,C are the column data in my table.

This is the final result I am trying to get:

Table: StrResults

col1 col2 col3 col4 col5

---- ---- ---- ---- ----

1 ...

Only way I know to recover possible space back from allocated space is to reindex with max fill factor that you can afford. If scan density is low, you should...

Any help please??

Recap:

Package resides on sql server 2000 which is destination.

This package is suppossed to xfer data from sql server 2005 to sql server 2000.

I understand that I can not connect to...