try these I guess will help to solve the issue....

http://www.netapp.com/library/tr/3431.pdf

http://www.netapp.com/library/tr/3323.pdf

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops4.mspx

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/sap-top-10.mspx

vyaskn.tripod.com/sql_server_security_best_practices.htm

vyaskn.tripod.com/sql_server_2000_fast_answers.htm

Data Mining is a method of searching data with mathematical algorithms to identify trends and hidden patterns, profile customers, and then predict how these trends or customers will behave in...

chec this out!!!!!!!!!!!!

http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

Sandy,

Check out these examples and try to build your own functionality....

http://www.lakesidesql.com/articles/?p=12

johnfermor ,

I thought this will fairly give you some idea on SP stuff and calling the same into sql's. Please go through & try this....

http://www.macronimous.com/resources/stored_procedures_for_ASP_and_VB_Programmers.asp

Henrik,

My suggestion would be if you fail to restore the back up database through the sql wizard then take the LIVE database offline. Ensure before doing this, you have...

Re-write the SP with a new logic by cutting down the lines so as to extract the result set. If you still run into problems try executing the same with...

Try this....

msdn2.microsoft.com/en-us/library/aa216173(sql.80).aspx

Try this site....

msdn2.microsoft.com/en-us/library/ms190312.aspx

Date and time data types for representing date and time of day.

datetime

Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one three-hundredth...

i'll agree with the comments posted by Cory Ellingson....

I guess Andras is Right. This SP should work for you against the spec given by your employer/client.

Can anybody tell me on what exactly are we teamed to discuss the issue. I'm not able to understand of each & everybody's conversation.....

I'm not sure whether this give us atleast 25% satisfication to which result set you have been aiming for.. but thought of send this link....

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21803338.html

http://dotnetslackers.com/articles/sql/UsingSQLServerIntegrationServicesSSIS.aspx

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=804008&SiteID=1