Viewing 15 posts - 166 through 180 (of 218 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...
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...
April 7, 2010 at 5:23 am
Why does the server get restarted automatically?
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...
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...
April 6, 2010 at 4:19 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...
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...
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...
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...
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...
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...
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...
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...
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...
April 6, 2010 at 11:32 am
Viewing 15 posts - 166 through 180 (of 218 total)