Did you create the database from a backup and restore operation or attached detach?

If so it is possible that the user exist in your database but not on master. That...

This might help.

I ran a trace on SSMS and got the SQL out of it. I changed it a bit to include the OBJECT_NAME lookup.

SELECTsigs.[name] as [NameOfCertificate],

obj.crypt_type_desc as [SignatureBy],

'['...

Unfortunetly I am working in an environment that is Pharma related and we are not able to make copies of production data to development or validation environment.

So we need our...

You can use the UPDATE method that test if an update was made to that column in your trigger.

 IF UPDATE(myFirstColumn)

      INSERT INTO myHistoricalTable...

Thank you I needed to confirm with someone.

I have restarted both servers. The problem goes away when I get to this weird locking.

I had to, some reports needed for upper management. So now I do not have...

Anti virus fully updated regulary OS updated too.

I have to admit that I am still on SP3

I am think about not sleeping tonigh...

When I say it does not work I mean that the query will just hang.

I am querying a table with 3 rows. It should not take more then a nanosecond...

I tried SET TRANSACTION ISOLATION LEVEL READUNCOMMITTED  with no succes That was my first guest )

Now the 2 new tables I created cannot be...

More Info :

On server A I can query a single table a time. But when I try to join 2 specific tables it will not resume. On server B I can...

Horror story ?

Thanks Phil you have confirmed my theory that theres no other way in EM.

I never thought of winzip to compress I guess I never had this problem before :0)...

It's a project management tool . It's not a very well known application.

I still have to get together with the software support to see if theres a way to reduce...

Will differential allow me to restore point in time?

The log file (.ldf ) is always 1000 m and each time I perform a transactional backup space within this file is available. The space taken ( transactions ) is move...