Arent there even some that will pay you some small amount for the computer time you provide? I'll be looking into this a little more for a follow up, both...

I took the path of making a full backup of SQL and the server, then running the upgrade wizard (no problems encountered). Once the upgrade was complete, I moved the...

To query across more than one database the best way is to add a linked server. Takes 10-15 mins the first time. Try BOL and see if you can get...

No problem at all, here it is:

http://www.sqlservercentral.com/columnists/awarren/reattachingdatabases-somecodeandacontest!.asp

Not sure why you're not seeing search, try this link:

http://www.sqlservercentral.com/Search/fulltextsearch.asp

Andy

One additional note, it's not necessary to copy the mdf/ldf files, just rename the folder. Once you've run rebuildm and are running, you can move all the files back into...

Are you sure the ISO codes won't change, or at least very unlikely? Overall I agree with Steve, no reason not to use a good candidate for the pkey. Size...

Steve - Im not convinced Robert is right btw, just that TS is handy for such things! His explanation makes sense, but I'd like to see some empirical evidence, Netmon...

I have them on my machine at home. Something to do with the diagramming tool?

Andy

No built in way that I know of, usually you BCP the data out and then have a script that loads it back in. Red-Gate sells a tool that will...

Have you tried replacing the value with a 0 to see if the proc works then? Any chance someone has modified a column width on either publisher or subscriber?

Andy

If you have Terminal Services installed you can do it without a trip to the server room.

Andy

Just from 7 to 2k, or bi-directional? I don't see why it wouldnt work that way as well. Only gap I can think of is that pull might work a...

I didnt think functions worked in constraints either, though I haven't spent much time trying to get it work yet!

Andy

You can override the behavior by doing this:

Syntax

SET CONCAT_NULL_YIELDS_NULL { ON | OFF }

This gives you a much more granular way of applying the setting - I will often...

Pretty cool. So are they true templates using form fields, or some custom data marker? Planning to complete each from within Word/the document?

Andy