J DBA (3/11/2014)

---

It was the DST change that got me. I was so tired that the double negatives confused me and I answered in the double negative and selected...

Koen Verbeeck (3/11/2014)

---

Great question.

Although the IDENTITY property doesn't always transfer:

When an existing identity column is selected into a new table, the new column inherits the IDENTITY property, unless one of...

Yes, initially I have drafted the question straight forward but it looks very simple. Deliberately make it complicated by tricky language to make challenging.

Usually everyone knows correct answer but...

Hello Marsha,

Thanks for sharing your experience it might help someone.

I guess, after win 2003 concept of trusted domain has been removed and controlled by GPO if under the same network.

Execute following:

select * from sys.symmetric_keys

HTH

Good question, need to do some research.

Good one, Andy. Thanks.

Have you installed 2008 R2 with new instance or done the upgrade the existing 2008 to 2008 R2?

Jack has provided ideal solution. If db Role is having db_owner surly you can't restrict Drop or Restore database. By default it can perform all db roles.

Ask you system admin to trust relation between domain X and Y. He will able to help you out.

Manoj,

Provide more detail what exactly you would like to achieve so that people can help.

Cheers!

is this your production server?

Yes, it is quite possible to replicate data in cross domain.

You must have trusted relation ship to make it work.

HTH

Easy one, thanks.