Viewing 15 posts - 5,701 through 5,715 (of 9,244 total)
Hbruce (4/14/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2012 at 8:47 pm
Why aren't you using .net roles and authorisation it has all you need for this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2012 at 8:36 pm
Log shipping would work, you just need to make sure that the administrator at the time of any failure is well versed at bringing SQL server databases online and general...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 12:36 pm
KTG (4/13/2012)
I know I am leaving a lot out
Way too much for us to make a sensible recommendation.
KTG (4/13/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 12:26 pm
praspras42 (4/13/2012)
I just want to know that can i write a
procedure with the help of which i can take the
backup of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 8:16 am
ha haaaaa, bollywood comes to SSC 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 7:45 am
Henrico Bekker (4/13/2012)
Sys db's on own diskuser db's on own disk.
I never see a need to dedicate a whole drive\volume to what are essentially little used and extremely small...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 7:21 am
Can you detail the exact steps you are taking and the options you are using to create the linked server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 7:14 am
chumphrey 12211 (4/12/2012)
SELECT NAME FROM sysusers WHERE issqluser = 1 and (sid is not null and sid <> 0x01) and suser_sname(sid) is NOT null ORDER BY name
Firstly, use the catalog...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 6:24 am
chumphrey 12211 (4/12/2012)
SELECT NAME FROM sysusers WHERE issqluser = 1 and (sid is not null and sid <> 0x01) and suser_sname(sid) is NOT null ORDER BY name
Firstly, use the catalog...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 6:23 am
Are you wanting to remove the server level login or the server login and the database user?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2012 at 1:41 pm
Always On in 2012 works the same, one full backup and restore followed by at least one t-log backup and restore. More importantly bear in mind this scenario
full backup at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2012 at 1:38 pm
Greg.Jackson (4/12/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2012 at 1:31 pm
a quick through the DMVs would have been helpful but to late now
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2012 at 10:41 am
Thinky Night (4/12/2012)
New question:
Can i see all pages in a database with a command like DBCC IND?
OR
How...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2012 at 10:38 am
Viewing 15 posts - 5,701 through 5,715 (of 9,244 total)