MDAC should be it.

Steve Jones

steve@dkranch.net

Let us know and we can add it to our development efforts.

Steve Jones

steve@dkranch.net

Personally, it seems that not much is being said about AD all around. In fact, the last few .NET presentations I have seen haven't mentioned it at all.

Has anyone completed...

Clustered servers shouldn't give any help. Clustering is a fault tolerance, not a performance increase. The query executes on one box (still).

For partioned views, you get two types of...

I agree there isn't a good alternative. IMHO, it's poor practice to allow an application to log in without requiring a user to log in as well.

The only good solution...

Yikes, that could be a really large case statement. I'd look at some other method of handling this.

rgibbons: I used the @ symbol to give me something that wasn't used...

I think that other knuckclehead was Genghis Warren.

Glad you guys agree. This is one area that I think causes more problems than it solves.

I hate embedding logins...

Glad it will help. I've got some more details for how I handle the other side of the backups I will post soon.

Steve Jones

steve@dkranch.net

I tend to agree with Andy, though I dislike sharing boxes for 2 load intensive apps, especially for different clients or departments. They are always battling. In gerenal, however, you...

Ab-so-lute-leeee agree. NO WAY should developers be working with product, except as read-only to look for data.

Steve Jones

steve@dkranch.net

The design book is definitely me. I go by Steve Jones, but actually I am J(ohn) Steven, so some of the distributors got it wrong.

Steve Jones

steve@dkranch.net

I ahven't tried this, but perhaps using the new table datatype in SQL 2000 would work?

Steve Jones

steve@dkranch.net

Maybe its even a little "job security". Don't make too many notes, Paul! 🙂

Steve Jones

steve@dkranch.net

DTS - wasn't sold, but use it more and more. I like the chaining features of different tasks, though it's mainly for simple tasks, like auto generating excel, my push...

Raj: your welcome. Nicely written.

(and everyone): please do send suggestions to Andy (awarren@sqlservercentral.com) or myself (sjones@sqlservercentral.com). We are always looking for new topics. Let us know specifically if what you...