It's close to the book, but there's much more in the book.

In terms of...

You are welcome, good luck, and if you have more questions, post away.

I'm not quite clear what you mean?

The two applications don't matter if they're sharing the same data. You just have code and tables, and you call what's appropriate from each...

I think what's confusing is you say "separate 1 for the data, and 1 for the code/engine", but you say 2 applications. So are you proposing, or dealing with:

db1

- data

db2

-...

We have a "join the discussion" link at the bottom already.

I suspect we need to come up with something else.

Let's do the time warp again.....

Just generated a new Win XP key. Feels strange.

If that's the reason, two apps, use schemas or something else. Having it in two databases isn't providing performance gains, and potentially this is a greater administrative headache.

I've seen this in cases where you have multiple clients and want to separate their data, but the code is all the same.

However when I've done this, I usually use...

FWIW, I haven't found support for GP to be top notch. They used to insist we run GP under "sa" until we pointed out there wasn't a reason for this....

There isn't a good way to do this. It isn't tracked per se, so you can't be sure when someone last used a database.

If you suspect no one is using...

Brandie Tarvin (1/23/2012)

---

WHEEHAW!

Delayed due to technical difficulties, Latchkeys is now out on Kindle. Here's the U.K. Kindle version and here's the U.S. Kindle version.

The Nook versions are supposed to...

Like this? 😀

Good question. I'm not sure. What would drive you to view the discussion?

We have a basic HTML5 app at http://www.sqlservercentral.com/mobile for the question of the day.

We haven't enhanced that for forums, or articles, since it is a decent sized project and we...

Gus,

I wouldn't call experimenting "jiggling". Now if you try things and then slip that code into a deployment without understanding it, which implies incomplete testing (how can you write tests...