OK, so I guess now I can be Barf.

I'm a mog: half man, half dog. I'm my own best friend!

It's nice to have a best friend.:-D

Some time ago there was a thread entitled "Should you use your real name as nickname?".

Maybe it's time to start the "Should you use your real pic as avatar?" thread?...

If you are working on the same phisical machine, you should install a new instance of SQLServer, exactly as you installed the first one. You don't have to uninstall anything:...

If you put both...

Add filter conditions for the main table (TableA) in the WHERE clause, then add filters for TableB in the JOIN conditions.

SELECT *

FROM TableA

LEFT JOIN TableB

ON (TableA.ID1=TableB.ID1 AND TableA.ID2=TableB.ID2 AND TableB.AnotherStat='B'...

Let's cut the whole thing into two parts:

1) Orphaned user 'qc'

2) Users not logging to databases

For number 1 I still suggest changing db owner. Change it to what it already...

Yes, you can do it. Nothing prevents you from installing two versions on the same machine.

Have you tried sp_droprolemember 'db_owner', 'yourAccount'?

An alternative to this is sp_dropalias 'yourAccount', which is deprecated but should still work.

I completely agree with you, Adi.

Run sp_helpdb dbName.

What do you get in the "owner" column?

Rob Goddard (8/11/2009)

---

As above post, I'm in the UK and setting the default login language to "British English" will render the format "YYYY-MM-DD" useless unless actually specified with 120 in...

This is what I get in my US-English instance:

select convert(datetime,'31/12/2009',120) --FAILS

select convert(datetime,'31/12/2009') --FAILS

select convert(datetime,'2009-06-30',120) --WORKS

select convert(datetime,'2009-06-30') --WORKS

SELECT isdate('31/12/2009') -- Returns False

SELECT isdate('2009-06-30') -- Returns True

Running the provider out of process is exactly what you did: uncheck allow in process.

The main difference is that when SQLServer loads the provider in process, takes the provider inside...

Check your default language in the server properties, advanced window.

SET LANGUAGE implicitly sets the setting of SET DATEFORMAT.

Regards

Gianluca

Check who's the database owner.

If it is your 3rd party sw user, run sp_changedbowner to assign to another user.

Hope this helps

Gianluca