1,759 reputation
11537
bio website about.me/daveforgac
location Cleveland, OH
age 34
visits member for 5 years, 1 month
seen yesterday

Nov
6
comment How can I give a SQL Server user permission to run one stored procedure and nothing else?
Well the permissions were applied without error but now when I execute xp_fixeddrives as the new user I get 0 results.
Nov
6
comment How can I give a SQL Server user permission to run one stored procedure and nothing else?
Thanks! I added the public role on the master database to the user and then was able to set the permissions as above.
Nov
6
comment How can I give a SQL Server user permission to run one stored procedure and nothing else?
I get: "Msg 15151, Level 16, State 1, Line 1 Cannot find the user 'dforgac', because it does not exist or you do not have permission." I am logged in as a server administrator using Windows Authenticaiton so I should have permission. The username exists.
Nov
6
asked How can I give a SQL Server user permission to run one stored procedure and nothing else?
Nov
6
accepted How can I find the amount of free disk space only using SQL Server?
Nov
5
asked How can I find the amount of free disk space only using SQL Server?
Nov
5
comment Error in services.msc: Error: 54 Unspecified error
Reboot: Yes. Update: No. IE install: No.
Nov
5
asked Error in services.msc: Error: 54 Unspecified error
Oct
24
answered Qmail/Plesk email help
Sep
29
answered SQL Server 2005 - Logs not being deleted
Sep
24
answered No DNS Resolution
Aug
29
asked How can I force users to send mail using submission port (587) with Exim?
Aug
26
revised How to redirect root and only root via htaccess?
added 10 characters in body; deleted 4 characters in body
Aug
26
answered How to redirect root and only root via htaccess?
Aug
26
accepted How can I configure Exim to drop non-authenticated connections on alternate SMTP port?
Aug
25
asked How can I configure Exim to drop non-authenticated connections on alternate SMTP port?
Aug
22
comment Is is possible to change the ntext size limit in SQL Server 2005?
It looks like they're using the text-in-row which is limited to 8000 bytes: msdn.microsoft.com/en-us/library/ms173530.aspx Working on convincing them to convert to nvarchar(max).
Aug
22
accepted Is is possible to change the ntext size limit in SQL Server 2005?
Aug
22
comment Is is possible to change the ntext size limit in SQL Server 2005?
I'm trying to help someone else with their server (I try to stay away from SQL server in general). They are reporting that data larger than 4000 characters is being truncated when inserted into a ntext field. Any idea why?
Aug
22
asked Is is possible to change the ntext size limit in SQL Server 2005?