I know of no way to figure it out other than query every column to figure out what the largest value is. Then set the max to that or larger....

If the option has been used, you could query Active Directory. If not, you'd have to a get a list of all servers (DMO has a method for this I...

Not much to it. Temp tables are private to the user. To use a permanent table to do the same thing you first create the table and grant appropriate users...

I'd suggest making it work in VBS to start with, then porting it to TSQL if you have a reason (or interest) in doing so. As I remember you can...

What makes them a better community? We're always looking for ways to improve.

Im probably the only one that will say this, but I wouldn't rule out uniqueidentifiers in all cases. Especially if you need the ID to do a parent/child insert using...

I would use a permanent table, save the overhead of creating/removing the temp table each time. Definitely you want to close the connection and that makes temp tables expensive.

Generally web sites use one account for all data access, can be a Win account or a sql login. Then you right separate code to authenticate/authorize the user to do...

Ran across this, might help:

http://www.cryer.co.uk/brian/sqlserver/mrgagnt_spi.htm

Agree that either way will work, though I like modifying the proc more than using the trigger - cheaper to not do the work. You could also use an instead...

I agree with that. If you're at that Zen level where you test all your options. My comment was directed more to provoke thought, as I see a lot of...

I agree, if there is no connectivity you have to work a lot harder. Depending on the enviroment, sometimes you can get everyone to agree to set up a VPN...

Try adding set quoted_identifier off at the top, or change the double quotes to two single quotes. The @TheKeyword <> null is bad, should be is not null.

I've found it happens when someone deletes rows from the subscriber 'by accident'. Easiest way to fix is to either do a new snapshot (very brute force, but effective), or...

Interesting. I know the wizard adds/drops indexes as it schemes along, just doing that shouldnt affect replication - unless it tries to change the primary key, that would not work...