Short answer is No, not out of the box.

There are some things you can do to the data. at the column level

Todays article

http://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp

But I have always had to have...

 autonomous transaction pragma =

http://www.unix.org.ua/orelly/oracle/guide8i/ch02_02.htm

But what does this have to do with the use, or absense of an identifier.?

Are you trying to guarantee the Key values are synchronous, No gaps?

Is...

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...