Thanks a lot John

for your support on this. I have added few more information as well

Both Server and database collation are same and set to Latin1_General_CI_AS. Even the Indexed Column collation is same.

One more thing about my SQL 2005 test databases is that they all restored...

I think you get some more info if you run the profiler against the sql server and catch

1. Event Class = Security Audit, Event = Audit Login, Login Failed, Audit...

This should also work asuming you don't care about the trailing blanks.

select

CompanyName

from MyCustomers

where len(CompanyName

Another option is to change the data type to Binary and manage the timestamp column on your own. you can get the next timestamp value for your db using this...

Got very frustrated when the examples were not working. MERGE INTO is no longer supported by SQL 2005. Other than that not a bad article.

if the results are in grid mode then you can right click on the top left corner of the results (left most empty box on the column header) and select...

This will only list the records with duplicate stud_ids

select stud_id, last_name, first_name

from stutable1

where stud_id in

 (

  select stud_id

  from stutable1

  group by stud_id

  having count (stud_id) >1

&nbsp

order by...

Raise an error in the SQL Query Task like below..

RAISERROR ('Error Occured',16, 1)

and it'll follow the failure path.

not that hard, but you get 21 points

Go to GEnerate SQL script wizard in the EM

Seelct relevant tables

click on the formatting tab and uncheck all

go to options tab and check Indexes

You will have a nice script to create...

Hi Brian,

thanks for your input. I found another reason , which probably is the reason why it's not getting populated in my case.

when you have a join to a temparary...

Even the answer C is wrong. This doesn't change anything in the options database but another database called "2test"

C)Run the following commands in Query Analyzer: sp_dboption '2test','trunc. log on chkpt.','false' go...