For what its worth, the output of PRINT will render when the batch has COMPLETED, whereas RAISERROR will render immediately. This may explain why you're seeing RAISERROR output before PRINT

My preferred method is to import the MS Excel file into a SQL table for verification. I usually set all the columns to a wide NVARCHAR value

You can create a...

From what I understand you want to keep a copy of the live database available for the next five years?

If that's the case, do the following:

1. Backup up the database

2....

At the risk of repeating myself, what do mean by Archive? Archive has no real meaning in SQL Server.

Try Googling the phrase

sql server archive

and see if you can get...

Needed to do some research for got the question right.

Great question although I got it wrong by missing the (0)

When you say "archive" do mean:

1. Backups?

2. Remove older or inactive records from a database?

3. Keeping a live copy of the database somewhere?

4. Any other definition not covered above?

The word...

Good article and clear explanation.

Had do refactor the INSERT statements as my organisation uses SQL 2005.

A quick Google search turned this up....

http://blogs.msdn.com/b/sqljourney/archive/2012/03/16/sql-2008-r2-setup-fails-with-quot-wait-on-the-database-engine-recovery-handle-failed-quot.aspx

Hope it helps!

Great tricky question!

Just checked.... the link is fine

http://www.sqlservercentral.com/blogs/jamesserra/2012/01/25/improving-cube-processing-time/

Great piece of SQL J Livingston - you've beat me to it again... I was working on a CTE solution...

Next time....

Hi Rajesh,

Open the link and read the article - it should point you in the right direction.

Found this in SSC which discusses cube updates.

http://www.sqlservercentral.com/blogs/jamesserra/2012/01/25/improving-cube-processing-time/

rajeshpalo2003 78748 (8/20/2012)

I am new to SSAS.i have 1 lakhs record in cube but next day i am getting another 10k records.So i want to process only new records.For...