I definitely agree with Jeff - perhaps your stored proc is doing much more work than is required.  We need some background to the problem to better help you.

However, I...

Straight from the horse's mouth...

http://support.microsoft.com/kb/224071/en-us

Describes moving all of the system databases - tempdb, model, master, msdb, etc.

The following code works - how is yours different?  The year function is exactly what you want to use.

You do not want to cast the datetime variable to decimal...  DateTimes...

Hi - you needn't cross post as we see all new messages in all of the forums anyway.

Thread is continued here (http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=288343) already....

I tend to err on the side of caution - I'd never expose SQL directly to the net.  A VPN using the standard MS PPTP connections is very easily configured...

No problem!

I think you can configure SQL Server to accept queries via IIS.  I haven't done this before but have read about it on this site before.

SQL Server uses its own...

It really depends.  SQL 2005 certainly has some nicer features such as mirroring, etc.

But in SQL 2000 you could do log shipping.  The wizard for this only comes with 2000...

No, it shouldn't have any trouble.

Are you obtaining the data directly from a table or from a SQL query.  If the latter, I'd try running the query (but with a...

Prakash, I think you misread the question.  It's about ODBC, not DBCC...

Anyhow, you certainly can pass just about any SQL command through...

as it is want to do

From this Q&A (which is poorly formatted / written) at http://www.eggheadcafe.com/aspnet_answers/dataoledb/May2006/post26836065.asp it appears that you can make...

The temporary tables prefixed with a single # are scoped within a single database connection.  Thus if you have 10 hits on your website then you might have 10 concurrent...

kkam, you are correct.  Hmmm - I thought I had done so before but obviously not... Perhaps I was using a UDF of some sort as the source.

In any case,...

bcp = bulk copy program.  There's a command-line app shipped with SQL called bcp.exe.  It lets you dump the contents of a table to a disk file and also lets you...

but you may need to issue a RECONFIGURE WITH OVERRIDE statement.

EG - to set some ANSI defaults on SQL and have it apply straight away

exec sp_configure N'user options', 376

GO

RECONFIGURE WITH...