Nevermind

With Black eye, and scars to prove it

And your restore process happens daily?

Once you have the logs backing and shipping you can delay the restoration, then start up again, Or I would suggest you leave them continuously...

Well, If you post an example of your table,

and some sample data, and also the query you are using, I'm sure someone can look at it, and try to...

Sell I would recommend that you do not do embedded sql in your application, but thats just me.

I'm not exactly sure if you can do this so give it a...

I guess for clarity, Are you doing differential backups in your maintenance plan?, or Log Backups?

If it is log backups then you do have to apply all the logs in...

This is me thinking out loud, but I have done this before with a web hosting company called webhost4life. They support creation of databases and with a sql login, I...

True that!

Without seeing any of your data, or the query you are using,

the way you are presenting your results I would think that you have to join to some kind...

How are you currently summarizing?

Please post your query, and some sample data, and how you would like the output to look. Have a look at this.

Use Pubs

select Stor_ID,

       sum(case when...

Does your statement look like this?

DECLARE @rowcount INT

INSERT dbo.User_CIS (

User_ID,

Ad_Source

)

VALUES (

@user-id,

@AdSource

)

Select @rowcount = @@rowcount

IF @rowcount > 0

Return -1

This will always evaluate to true, because after your insert, @rowcount will...

Not sure why it says that in Books Online, in my opinion Log shipping is not a good solution for moving data to a Reporting database. It is best used...

In the beginning of your procedure. your setting @rowcount = @@rowcount. Since no operation or query is being run before you set this, it is setting it to...

Yes the restore job will fail, hanging up all other restore jobs.

A destination database in log shipping cannot have any open connections during a restore, So attaching an application to...