I like the idea of always specifying a default database in the connection string. I'm guilty of not always doing it and your article makes me resolve to start....

Perhaps what we're doing will work for you as well. We have an ActiveX EXE VB program that runs full time on a server. It's job is to...

Thanks a bunch for the article. I didn't go to PASS and now I wish I had. I'm also from Orlando and I've made that Seattle trip before...

quote:

---

I find it easier to have the proc initiate a job that runs the app - ok as long as async completion...

If the users are changing on the primary database I don't have a good answer. If they're not, and just the data is changing here is how I'd do...

I should have also mentioned, when it starts taking too long to do the first backup across the network (due to database growth), we plan on simply putting Gigabit cards...

We use the built in utilities. First at 1:00am we do a full backup under one maintenance plan to another machine on the network (we're lightly loaded at that...

Steve, you had me all happy. I read and reread the article and headed for the site. THEN I found out that it's just for 2000, and there's...

Good article, Steve. When I first read the error message, my guess was that you had 'run out' of numbers on the Identity column, it's happened to me before....

Goughj's answer is the only way I know to do what you are asking. However, you may want to break it down a bit further than that for a...

I don't like the ordinal order by, but for a different reason. I would hope that if you are altering the Select portion, you'd have enough sense to look...

Thanks for the ideas, Andy. It's pretty clear that we'll be using something like this as we make mods to our products. I'm not about to walk 400...

Andy: Good article. It's focused, clear, and you make some good points. Besides, you agree with my point of view.

Student of SQL and Golf, Master of Neither

I thought briefly of using the GUID, but this excerpt from BOL changed my mind:

The uniqueidentifier data type has several disadvantages:

The values are long and obscure...

The values are...

In our main application, almost all use is by internet users calling our database from a vertical market application. Each one has a login (SQL of course) and it's...