Bruce, thanks for the question. We welcome readers of all levels! Read for a while, ask a question when you have one, pretty soon you'll understand a lot more than...

I would double check the permissions on SheetDates. Once you get your problem resolved, I'd recommend that you put the login in a separate role and remove it from dbo....

Try reinstalling just the client tools. Be careful if on a server.

Andy

We've been running native for quite a while. 8 or 9 servers, 300 or so desktops. No issues. No big gains, other than running Win2K itself - much nicer platform...

You're in 6.5 compatibility mode. Top wasn't a feature of TSQL until 7.0. Take a look at BOL for sp_dboption to see how to change it.

Andy

So far all my queries are running on one box. I would think that if you're using distributed partitioned views there might be some gains.

Andy

I heard the same thing, no reference handy either. If it happens, definitely changes the role of SQL in the work place.

Andy

The problem with embedding login/password is there arent any simple good alternatives (depending on your definition of simple and good). If you're going to encrypt something, do it well or...

I would add that many people do not interview well or test well, so it might be worth digging a little deeper to find out. I think the real point...

If you have a consistent record id column that would work. Take a look at these two articles (be sure to read both!):

http://www.sqlservercentral.com/columnists/jwiner/returningasubsetofarecordset.asp

http://www.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset_1.asp

Andy

Very well said!

I totally agree. The arguments I get are "this is the only user I'll ever need" which usually occurs because the developer will be using a sql login...

You're not. Double edged sword. You can easily keep all BUT sys admins out. Think of it much like NT/Win2K on a network, you need someone who is all powerful...

Select Top N is your best bet.

Andy

Probably the cookie support missing?

Andy

Performance is not great from what I've seen. I think it makes sense to pull out the data you need and table it, build some kind of replication scheme to...