Probably a xp_readerrorlog is stuck and it is waiting for that to return.

You can have a look on the server for any tasks that look like they might be associated...

There is a fault in the ssis package and it won't run.

It should give you error messages about the build.

Which version are you usoing?

update tbl

set u = case when val1 = '.' or val2 = '.' or val3 = '.' then 'U' else 'u' end

Getting away from the original question but:

I don't think there is anything wrong with implementing something that goes against theory (as in database engines or most databases) as long as...

I started with set/group theory and topology (part of a maths degree).

Then a relational databases course which was about the theory and included a lot of sql and relational theory...

http://technet.microsoft.com/en-us/library/bb497962.aspx

A restore is the simplest - but there may well be a script you need to run after the restore (see below).

As to the datatransfer packages - what do you...

See

http://www.simple-talk.com/sql/database-administration/partitioned-tables-in-sql-server-2005/

If you look down it has a section on adding and removing partitions - was written for v2005 but is still applicable.

Oops - didn't think row_number() was available in v2005.

Still seems new.

option (maxrecursion 0);

Will keep going.

create table #TEMP (slno int, received int, BALANCE int, paid int)

;WITH CTE_BALANCE(SLNO,RECEIVED,PAID,BALANCE)

AS

(

SELECT slno,received,paid,CAST(ISNULL(BALANCE,0) AS NVARCHAR(64))

FROM #TEMP WHERE SLNO=1

UNION ALL

SELECT t1.slno,t1.received,t1.paid,CAST((ISNULL(T1.RECEIVED,0) - ISNULL(T1.PAID,0)) + ISNULL(T2.BALANCE,0) AS NVARCHAR(64)) BALANCE

FROM...

At the end of the statement

I would look at why you think you need more than 1024 columns in a report.

Could probably be simpler but this separates out the steps.

declare @t table (s varchar(10), dt datetime)

insert @t select 'A', '20120101'

insert @t select 'A', '20120102'

insert @t select 'A', '20120102 01:00'

insert @t...

Do you want to answer the questions I asked?