Actually Lynn, it is a little smoke and mirrors.. I'm working on an article related to Synonyms as border objects, which is what you are suggesting. However this...

Oh, I fully agree, I try to take seconds(or fractions) out of the equation, but novice developers often (usually?) forget these ramifications. As a matter of fact I'd rather...

Nigel,

I was trying to figure out what you were trying to accomplish with your end date formula, I think I finally understand. I hate dealing with time when it...

It is a SQL 7/2000 group..

CEWII

Have you tried moving it back? Also I see you are running in minimal config mode, have you tried -m for single user, not sure it will make a...

Bob, wasn't that what I suggested?

CEWII

Your post is somewhat unclear, let me see if I can clarify. You have a database you want to replicate that is in SQL 2000 that gets updated a...

I'm curious why you are passing dates at all since it seems you know what values you want on any given day. Put the calculation logic into the sproc...

Wayne,

As far as linkedservers you will absolutely need 64-bit drivers, but using linked servers for text files or CSV or Excel files is just a bad idea regardless of 32...

I think it is pretty easy to enable, I just REALLY don't suggest it.. You might create views on those tables in the other DB and grant access to...

You could, although it pains me to suggest it, use DB Chaining, and as long as the tables (and I think databases) are owned by the same user you don't...

I think the Tech Republic article was pretty good..

I have some additional questions.

1. What will the front-end be?

2. How big do you expect this app to grow to?

3. What...

Just a thought, I have had several cases where the OS reports xxGB of free space but there really isn't that much or it is confused, in those cases I...

Some of the newer datatypes like the spatial ones (geography and such) are actually SLQCLR under the hood and the DB engine does not honor SQLCLR on/off for them because...

Also a good answer..

CEWII