Sounds awful... my sympathies.

Anyway, I might partition the table into multiple narrower tables that can be linked on an ID column. To do this you can use SSIS but you...

That (seems to me anyway) a reasonable size backup file. If you are actively restoring the transaction logs to the standby server as they are available every hour (with standby...

The reason you need full backups is to have a point to restart the log shipping mechanism if it ever breaks, or you recover the standby server for whatever reason...

email on the way

I was only trying to give you a general idea of how that can be done.

While I don't totally understand how your data is set up (and I have...

try something like this:

select D.caseid, sum(case when D.closedate = ' ' then 1 else 0 end) as stillOpen

from dbo.tblCase A

JOIN dbo.view_CaseLogDetail D

ON A.caseid = D.caseid

where A.closedate = ' '

group by...

just add an order by to the union queries if you need a specific insert order.

try this:

insert destination (membershipid membername membershiptype Flag)

select substring(membershipid,1,4), membername, membershiptype, 1

from source

union all

select substring(membershipid,4,4), membername, membershiptype, 1

from source

union all

select substring(membershipid,8,4), membername, membershiptype, 1

from source

SSIS is okay, if you have it available and want to take the time to set it up. My CSV generator runs on any box against any database or version...

I wrote a C# .net program that runs from the command line so you can put it into batch file. I takes a query (like: select * from table) as...

dang. Ya got me stumped. Have you looked in the SQL Server logs ?

run this query in master and see if any result set comes back:

select name, OBJECTPROPERTY(id,'execisstartup')

from sysobjects where type = 'P'

group by name, id

having OBJECTPROPERTY(id,'execisstartup') = 1

Here is how I implemented something similar for a comma delimited entity, that inserts the results into a table variable:

declare @theseaccounts as TABLE (lastpull char(8), account varchar(16))

declare @ii int

declare @pos...

Check the obvious first... see if there is an agent job that runs on start up that drops them.

reaching for straws here, but something could be happening to mess up your rowset... maybe one of the tables it first finds no longer exists by the time you get...