why not a multi-step approach

grab the data out of AD and display the first level of group membership. then run several queries to display the second and third levels and...

management studio is installed as part of workstation tools and you should also install SSIS. everything else is a server component

we have a consultant go into our Great Plains servers once in a while, but that is all they hit. anyone who wants to run anything anywhere else needs to...

thank you all

working on the code now to rename it with a dynamic name

if you are allowed, have you tried to alias the domain account you are running sql as to dbo on your servers? there is an sp for it, but i...

is there a kb article for this issue?

not the first time for MS

we had an issue where one replicated table would replicate a lot slower than all others. MS tried to tell me it was a hardware...

we used to have 2 SQL 2005 SP2 distributors and some time ago migrated to one 64 bit distributor that handles SQL 2005 SP2 and SQL 2000 publications. all transactional.

i...

or restore it under a different name and different file names or paths

transactional here and i always use the GUI to create publications and subscriptions

only time i used sp's was when we went to a new distributor a few months back and...

we had an issue where a select would default to an index scan on the PK because it was grabbing something like 3 million rows and at the same time...

strange, we do replication from SQL 2005 SP 2 to SQL 2000 and no problems. even reinitialized 2 subscriptions last night to some ancient sql 2000 servers we have. even...

run snapshot, run logreader and then start the subscrption to start the snapshot to the subscriber

make sure you connect to every server from SSMS

i never had a chance to test the script and was always afraid to run it for real at 2am. so we always did it manually.

to speed things up i...

i've never done it, but what you can do is set up a transformation to write all bad imports to a table to be worked on manually

the explanation is in...