Viewing 15 posts - 691 through 705 (of 1,138 total)
timscronin (9/16/2009)
So I should understand this to mean that I can not use a sql login for this process?
No, you can use a sql login for this.
what the example i...
September 16, 2009 at 9:27 am
Just a quick reply as i am curious, what sort of rates do contract staff tend to get stateside. the average here, if i do the conversion right, would be...
September 16, 2009 at 9:23 am
Atul DBA (9/16/2009)
I am facing this typical issue with high value for CPU usage and Physical IO on one of the SQL Server box. This is in a cluster environment...
September 16, 2009 at 8:57 am
This is quoted from the link that I just gave you
In SQL Server 2005 and 2008, to allow a non-sysadmin login to execute xp_cmdshell, you will need to create a...
September 16, 2009 at 8:49 am
Katmai Stratovolcano (9/16/2009)
Hi experts,One of our live server is showing high CPU utilisation.Why this is so?Please help
I am attaching a screenshot of activity monitor.
Thanks in ADVANCE
J.K
just as a side note,...
September 16, 2009 at 8:45 am
disregard the previous post, that extended stored procedure is only sql 2000.
This link explains what you need to know
http://www.databasejournal.com/features/mssql/article.php/3789881/Proxy-Accounts-in-SQL-Server.htm
September 16, 2009 at 8:31 am
luckysql.kinda (9/16/2009)
Is this true that it uses the cpu which has less load?
I have absolutely no idea and I would say no, because that would imply that it would be...
September 16, 2009 at 8:21 am
jabba-825017 (9/16/2009)
Is there any key differences in terms of the way you should configure a SQL Server, if it is on VmWare rather than a normal (non-virtualised server)?
The previous post...
September 16, 2009 at 8:06 am
luckysql.kinda (9/16/2009)
sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'max degree of parallelism',...
September 16, 2009 at 8:02 am
I would ask for your money back, if they cannot explain how their "Tool" detected this problem.
Did they mention which accounts could do this activity
All I can suggest, is that...
September 16, 2009 at 5:26 am
Matthew Bryant-584838 (9/16/2009)
Silverfox (9/16/2009)
k.przewozniak (9/16/2009)
I have mirroring implemented on 3 servers (1- mirror, 2 - principal, 3 - witness)
The problem is that there is not only one database to be...
September 16, 2009 at 5:10 am
k.przewozniak (9/16/2009)
I have mirroring implemented on 3 servers (1- mirror, 2 - principal, 3 - witness)
The problem is that there is not only one database to be mirrored but 10.
The...
September 16, 2009 at 4:48 am
SanthoshViswanathan (9/16/2009)
Non-privileged users had the privileges to discover the password used in the SQL Data Transformation Services (DTS)...
September 16, 2009 at 4:41 am
vkundar (9/16/2009)
find out the reason why the backup failed? Take another backup. Backup is very much necessary to bring up your DB from damage or corruption.
To follow on what was...
September 16, 2009 at 2:53 am
search for kill connections in the search box on this site and you will get numerous scripts
September 16, 2009 at 2:46 am
Viewing 15 posts - 691 through 705 (of 1,138 total)