Interesting also, is that when you create a PK on a table, in SSMS that it lists that PK under Indexes and not under Constraints.

Yeah this looks like the problem. Apparently fixed in SQL 2012, but no mention of hot fixes for 2008.

Anyway it looks like the problem with it defaulting to the domain\user3...

Hmmm think I have made some progress here...

I went back to the copy of the domain\user3 account and logged into the named instance. I then went to create a new...

I'm more than happy to provide as much detail as I can, if it helps to get a resolution to the problem.

Yes I created a new login on the named...

Results from the above on the named instance (the one that doesn't work as it should) are:

account name type privilege ...

Yep, there are no named logins, only the Windows Group, and that Group is not a member of sysadmin. All 3 users in that group are also Domain Admins and...

Hi arun,

Yeah, that's pretty much the same method as my first example, in the way that you are updating all columns regardless of whether they need updating (ie, you are...

Thanks for all the views guys.

I didn't think it would be possible to find this info. This third party app. is very poorly designed indeed.

There are many users logged onto...

Some progress made...

I also have another SQL 2000 server with SQL Mail setup using Outlook 2000. This one I managed to get working (after changing to a domain account for...

I was under the impression that it would start itself whenever mail was to be sent? I got that from here (Q17). I get these messages also in the error...

Working on a Unix system in the past for 8 years, I always used a blue background with white text. I found this quite easy on the eye. Might give...

I've now resolved this matter. It was the local account running the SQL Server Agent service that was the culprit. Once this was changed to a domain account with appropriate...

The "Query Execution" setting is used when you run a query using T-SQL in the query window. However, if you are using the table designer (right clicking a table name...

A couple of things for you to check...

Firstly, when you create your database connection File>Connect Object Explorer or clicking the Connect button in the Object Explorer. Click the "Options >>"...

I used an OLE DB Destination instead of a SQL Server Destination. Then you 'edit' the OLE DB Destination and choose 'Table name or view name variable' as the Data...