Two things.

One, with SQL Server 2005 and on tracking when objects are modified, I would be more inclined now to use ALTER instead of DROP/CREATE.

Two, I agree with deploying a...

My guess, little Snarky Malarky?

In fact it is at the top of the list for me right now.

I have noticed that sometimes it will show up in the Active Threads list and at other times it doesn't. Seems really strange.

By doing that, you have broken the log chain from the source database (client). About the only way I can see around this would be do shut SQL Server...

As stated earlier, you can only have one primary key. This key uniquely identifies a record in a table. It is possible to have other keys on other...

Actually, yes I do. Especially when someone else could have done it just as easily as asking a question here on SSC. 😉

You still have not answered the main question, how current does the data need to be for reporting purposes? Do the users really need up to the minute reporting...

Thought you said you knew how to use Google? 😉

Try starting here.

Right you are, back to ignoring it shall be.

The question that needs to be answered first is how current MUST the data be for reporting? If it must be as current as possible, then this is not...

ubernoob (6/15/2009)

---

Kit G (6/15/2009)

---

Under options on your forum account there are email settings. One of them is to allow others to send you email via the board. Might...

Just checking to see if your problem has been resolved or if you have that...

My first question is, does the snapshot really need to be that current? If there are specific reports that require data to be that close to real-time, then perhaps...

Okay, we started with this:

I have been asked to build an client-server application. The server application rests on the sql server and the client rests on user machines. the point...