Not sure how that could happen. If you had two different objects, calling a method on one would not execute it on the other (unless you have shared methods, only...

Im using compression on one server that is short on space, works well. Haven't done a comparision yet to see the time difference - don't have enough space to try...

Sometimes it will work - adding the hint that is. Downside is that if the index gets changed, query plan may not be as good. If the index gets dropped,...

SP's will always scale better. 200 users, or 200 concurrent users - there's a huge difference! I'll put up some code one of these days to show better, but you...

I've used it, so I know it's possible. Are you absolutely sure you do have permissions to access the file on the UNC path?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Depends on how big it is. Under 8k, just insert into an appropriately sized varchar/char/etc column. Over 8k (or if you just don't have room) put into a text col,...

I haven't tried dialup, I do replicate across domains over a dedicated link. In our case we used a trust. I think the only issue you'll have is that you...

Should be the account that runs SQL agent. Easiest fix is to get your admin to give the account access.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Makes sense! Thanks - good to see why the problem exists, sometimes offers opportunities for other solutions. Seems like you could easily host MSDE on another machine somewhere behind ISA,...

Do you have auditing enabled in server properties?

Andy

http://www.sqlservercentral.com/columnists/awarren/

How about making a table of possible product keys? Something along those lines?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Maybe you have a trigger firing that calls it? Or hitting an error in code that bounces the current line back above where the insert happens initially? What happens if...

Curious why you would want to do that?

Andy

http://www.sqlservercentral.com/columnists/awarren/

I just posted recently about having to deal with time issues because we're crossing time zones at the app level now. Definitely a lot of work to change everything to...

You can pull constraints from sysobjects where xtype=D, then hit sysobjects using the ID to find the code for the default in the text column. You could probably put something...