Viewing 15 posts - 421 through 435 (of 582 total)
check sys.database_permissions.
A good trick if you know how to do something with SSMS is to run a profiler trace of your own SSMS spid and you will capture the...
November 30, 2010 at 11:08 am
There would not be many situations where you would need to rebuild master; not having backup would be one.
November 24, 2010 at 1:09 pm
When we bring the virtual machine up since it has an updated copy of master and the same drive letters/pathing it should see the mdf/ldf files and reattach itself essentially
This...
November 24, 2010 at 12:07 pm
I am a bit confused now. Your first step says:
1. Scheduled P2V (Weekly)
I took that as you would be doing a physical to virtual every week. will you also be...
November 24, 2010 at 11:15 am
P2V should work fine, I have done it once with a database server a couple years ago and if I remember correctly, did not have to restore any databases. we...
November 24, 2010 at 10:42 am
I am pretty sure that once you do physical to virtual you will not have to restore the databases but you would need to change name and IP of virtual...
November 24, 2010 at 10:24 am
I have a question; when doing a physical to virtual conversion don't all the drives and what they contain get converted to virtual disks thus negating the need to restore...
November 24, 2010 at 10:04 am
you could also use a subquery http://msdn.microsoft.com/en-us/library/aa213252%28SQL.80%29.aspx
select company_name,s_post_code
from address
where s_post_code in
(select s_post_code
from address
group by s_post_code having count(s_post_code)>1)
November 24, 2010 at 9:48 am
I stated in my original post that the servers table has to be populated manually with the server/linkedservername. All other columns in server table are handled by the script.
ie.
insert into...
February 24, 2010 at 10:50 am
the table population is in the script. What part are you having trouble with?
February 23, 2010 at 1:15 pm
Thanks Jack, that is what I figured would be needed just wanted second opinion.
December 15, 2009 at 9:57 am
Thank for the replies.
Supriya, I was able to use your example to get the results I needed.
November 12, 2009 at 12:50 pm
here is a proc that can assist in moving logins between servers
August 18, 2009 at 12:31 pm
Did you read the link in my signature? If not, please do so then post example tables and data and I may be able to help you further.
in any case...
August 13, 2009 at 7:52 am
Viewing 15 posts - 421 through 435 (of 582 total)