Let me get this straight, you're passing in the entire SELECT statement as a parameter?

If that's the case, check the length for your datatype on the parameter for the SQL...

Very True.

LOL - sorry I didn't meant to use that directly, it was just a concept to show you how to calculate the difference between the two datetime fields. Of...

This is pretty vague...what exactly do you mean? Are you wanting to restore the latest backup from Production to Development from a specific point in time or are you wanting...

Use DATEDIFF()???

Example:DECLARE @Time1 datetime = GETDATE()

WAITFOR DELAY '00:00:05:789'

DECLARE @Time2 datetime = GETDATE()

SELECT DATEDIFF(ss, @Time1, @Time2)

result: 5s

-- So Something like...

WHERE modify_timestamps > DATEDIFF(ss, modify_timestamp, create_timestamp) > 1

Thanks Lowell:-)

If you run a snapshot via the GUI (which is what I always use) it immediately places table/object locks on the tables being bcp'd. This works okay for tables...

You'll need to take another backup after you've stopped the hyperbac service before you will be able to successfully restore it on the other server (remember to restart the service...

Yes, that will be the cause.

I know this seem like a silly question but do you have any other compression software running on either one of these servers i.e.(Litespeed or Hyperbac?)

If the database is too large and/or there are way too many transactions/minute we do not use snapshot, but sync manually, start replication, then sync again for info that did...

This is a highly active OLTP production server where we can easily take a 100 transactions/minute so creating snapshots (which place table locks) is not an option unless we carefully...

This route will allow it to be created but immediately results in errors stating that the rows are not found and the subscriber...

Seems like there should be a setting somewhere...

Adding a user to the datareader role doesn't necessarily give them access to the database unless CONNECT has been granted at the database level. Permissions are inherited, and depending...

Eugene Elutin (3/6/2012)

---

Much better now!

So, what else we can add:

1. they differ in purpose:

We are using PK for referential integrity (when paired with FK)

While UNIQUE NOT NUL index(key)...