Viewing 15 posts - 166 through 180 (of 219 total)
sanketahir1985 (4/7/2010)
but this is not applicable to xp_cmdshellto execute xp_cmdshell u must be sysadmin
else even if u grant permission to nonsyadmin user for xp_cmdshell, u won't get permission.
I beg to...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 7, 2010 at 6:16 am
sanketahir1985 (4/6/2010)
GregoryF (4/6/2010)
Krasavita (4/6/2010)
This link is not working, do you know where I can find out, what happend when you enable this command?
hiii GregoryF ,
how can db_datareader can have access...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 7, 2010 at 5:23 am
Why does the server get restarted automatically?
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 4:26 pm
karthik -450760 (4/6/2010)
One of the servers gets restarted automatically. I found the below error message in error log
"The client was unable to reuse a session with SPID XX, which had...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 4:22 pm
rambilla4 (4/6/2010)
Perfmon giving High Avg.Disk Queue length alarms of values up to 33 some times.
So is Perfmon takes consideration of the no.of spindles in each disk & then measures the...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 4:19 pm
Select @@ServerName
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 4:15 pm
Krasavita (4/6/2010)
This link is not working, do you know where I can find out, what happend when you enable this command?
When you enable xp_cmdshell what will happen is that the...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 1:09 pm
Krasavita (4/6/2010)
They don't have sysadmin access level, I want to know if you enable is command is any access level changes for users? Thank you
No, no SQL Server access is...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 12:53 pm
Are you looking at total transactions, or just "user" transactions into a certain database?
Monitoring = extra transactions
Jobs = extra transactions
DBA's = extra transactions
Again, if you really want to see what...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 12:44 pm
Trey Staker (4/6/2010)
GregoryF (4/6/2010)
CirquedeSQLeil (4/6/2010)
ps. (4/6/2010)
Lynn Pettis (4/6/2010)
It is difficult to provide you with...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 12:11 pm
pankaj.baluni (4/6/2010)
After reading all your responses, this is what I've come up with... Please tell if this will work for me or...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 12:07 pm
rkinney-802645 (4/6/2010)
Have to to install on production - no log shipping, no mirroring It budget is gone.
There is no safe way to do it. It's production. You have...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 11:50 am
rkinney-802645 (4/6/2010)
Instance2 will be placed into the cluster first
These are currently running production, right? Have you thought out what might happen if something goes wrong while you are building...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 11:41 am
Replication can be very have very high administrative overhead (plus if a table has no PK, it cannot be replicated)
Clustering is HA, but not DR. Clustering suffers from a...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 11:37 am
CirquedeSQLeil (4/6/2010)
ps. (4/6/2010)
Lynn Pettis (4/6/2010)
It is difficult to provide you with the assistance you...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 11:32 am
Viewing 15 posts - 166 through 180 (of 219 total)