Doesnt look like it! Have you given them a try?

Andy

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

You can use a view to combine them all for reporting, nothing wrong with that. Biggest issue will be primary key generation. Even using SSN alone wouldnt work, potentially an...

Now we're cooking - good discussion to have. Critical problems isnt bad either. What counts as critical is pretty tough - if you dont know how detach works and you...

The popup idea isnt a bad one. Will add that to list of ideas for topic control! Considered also just running a search based on the topic and showing the...

I've forwarded this on to Brian. I think I mentioned elsewhere that we're looking at upgrading or changing discussion software, havent finished that review yet. Lots of little minor bugs...

Tons of books, try half.com to pick up something cheap even if only for SQL7. Creating db's is about the same in SQL2K. Online you can hit http://www.msdn.microsoft.com or http://www.microsoft.com/sql...

Dont know if I can answer all...or even any! You can change the timeout of the distribution agent, easiest way is to change/add a param to the job. You can...

Not a dumb question. Dont see a simple way. Probably could use the spid to query sysprocesses, use that to look up in sysjobs.

Andy

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

Never had an issue with it. Have you tried to repro?

Andy

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

The point about needing an admin to help you do the restore is a big one. We back up to disk, then to tape. Also try to keep at least...

Not that I know of. I think we have a couple scripts that use CDO directly (mainly for cases where you're not running Exchange), might look at using one of...

Tolerance, man, tolerance! Wonder if yours is the first post with dingleberry in it?

Seriously, there is merit to your points, but most first time posters are a bit self conscious...

Both sound good. Brian, I agree about the timeliness issue, just wasnt sure how the community would want it. What about weekends by the way? We dont do much traffic...

A quick and dirty alternative is to make a copy of the table structure and create a unique index with ignore dupes on your key field(s). Then append the data,...

I think that makes sense - if you check the repair errors option the db has to go into single user mode. To get into single user mode you have...