it's integrated out of the box when you install it.

look up "windows authentication" in the books online documentation

well there's an environment variable for it.. so i just did a quick google and found this:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1056858,00.html

the environment variable you're after is USERDOMAIN

haven't tested it.. let us know...

Hi Jason,

Yep thats the ones. Did you then restart SQL and SQL Agent ? And is everything working as it should ?

One thing I forgot to mention -...

i use merge replication, not transaction replication.. so forgive me if this doesn't work.

yes. adding articles is possible. removing them is not (not in merge.. maybe in trans...

see the reply i just made on this post:

http://www.sqlservercentral.com/Forums/Topic451274-146-1.aspx

the SQL services do NOT need admin permissions and shouldn't.. why people are saying to do that I've got no...

I did some research into this a while back.

When SQL (2005) is installed, it automatically creates some windows groups (SQLServer2005*).

These groups have various permissions for different things.

So, create a domain...

bnordberg is on the right track, but you can't just remove the workstation manager, as that will cause other zenworks delivered stuff to fail, such as workstation import and...

Interesting !

I have to move data files for a merge replicated database next week, and in testing just came across this rather annoying problem in Sql2000. I have a...

Hi Noel,

THanks for that.  I've just been doing some testing and you're right.  That's really confusing, they could have worded those options better! 

The only way I've been able to...

cheers, thanks for that

thanks for the response.  Database was already in simple recovery.

i've increased it to 100mb, and done a shrink on the file to the minimum, so it's back to 1mb in...

After thinking about this I realise that's not a great approach.    I've found the application in question actually has a purge stored procedure which deletes data from all the big...