Viewing 15 posts - 496 through 510 (of 1,179 total)
J DBA (3/11/2014)
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 11, 2014 at 10:49 pm
Koen Verbeeck (3/11/2014)
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 11, 2014 at 6:11 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 11, 2014 at 6:02 am
Hello Marsha,
Thanks for sharing your experience it might help someone.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 10, 2014 at 3:21 am
I guess, after win 2003 concept of trusted domain has been removed and controlled by GPO if under the same network.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 10, 2014 at 3:15 am
Execute following:
select * from sys.symmetric_keys
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 10, 2014 at 2:22 am
Good question, need to do some research.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 10, 2014 at 12:17 am
Good one, Andy. Thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 6, 2014 at 11:41 pm
Have you installed 2008 R2 with new instance or done the upgrade the existing 2008 to 2008 R2?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 6, 2014 at 11:27 pm
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.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 6, 2014 at 5:30 am
Ask you system admin to trust relation between domain X and Y. He will able to help you out.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 6, 2014 at 5:00 am
Manoj,
Provide more detail what exactly you would like to achieve so that people can help.
Cheers!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 6, 2014 at 4:56 am
is this your production server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 6, 2014 at 4:49 am
Yes, it is quite possible to replicate data in cross domain.
You must have trusted relation ship to make it work.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 6, 2014 at 4:42 am
Easy one, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 5, 2014 at 9:54 pm
Viewing 15 posts - 496 through 510 (of 1,179 total)