The second parameter is the directory where the log files are located or NULL for the default location.

I understand very well the difference between ASC and DESC in an order by clause. Please don't insult my intelligence. You missed the point of the post. Try this:

-----------------------------------------------------------

-- Create Table

-----------------------------------------------------------

create table...

Thanks everyone for your replies. These are all viable alternatives and I will keep them in mind. But what I wanted to know is, if there is a system setting...

Thanks for the info Nicholas, it was just what I was looking for.

Thank you Wesley and Colin for your posts. They are much appreciated.

I can duplicate your error messages by specifying an invalid sql server in my bcp command. Check to make sure your remote server name is correct.

The Merge Agent is responsible for the initial synchronization of the schema and data at the subscriber. After the publisher and subscriber have been synched, the Merge Agent will handle all incremental data...

There are also system table views provided by Microsoft that can provide foreign key information. They are:

information_schema.constraint_table_usage

information_schema.constraint_column_usage

information_schema.table_constraints

You query them as you would any other table or view except you must...

Thanks everyone for your suggestions. I was avoiding linked servers only because the company I work for overuses excel files and it would have been a nightmare to try and...

You mentioned you receive this error message after a 'change to allow updates'. Are you allowing updates to your system tables? If you are, you must run the RECONFIGURE command...