SqlServer-QA.net

Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each agent and additional predefined profiles for the Log Reader Agent, Distribution Agent, ...

When you have a Vista operating system along with SQL Server, the common error you get when trying to perform any sort of SYSADMIN sort of tasks. For instance when creating a database:  TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for Database 'dbname'.  ...