Viewing 15 posts - 1,231 through 1,245 (of 1,970 total)
Recombinant (5/27/2016)
Kindest Regards, Rod Connect with me on LinkedIn.
May 27, 2016 at 8:21 am
OK, I'll copy it to the location you've given, but what permssions would I have to assign to the folder where it currently is, in order for it to work?
Kindest Regards, Rod Connect with me on LinkedIn.
May 26, 2016 at 12:26 pm
Wayne West (5/26/2016)
Kindest Regards, Rod Connect with me on LinkedIn.
May 26, 2016 at 8:20 am
Stefan LG (5/26/2016)
I always use Herzberg’s two-factor theory as a starting point...
Kindest Regards, Rod Connect with me on LinkedIn.
May 26, 2016 at 8:18 am
Jacob Wilkins (5/24/2016)
There's an active Connect item complaining about this: https://connect.microsoft.com/SQLServer/feedback/details/351698/msit-mso-debugging-sql-query-fails-with-an-error-the-execute-permission-was-denied-on-the-object-sp-enable-sql-debug.
The Microsoft engineer who responded initially said:
The minimum security requirement is sysadmin. This is by...
Kindest Regards, Rod Connect with me on LinkedIn.
May 24, 2016 at 10:04 am
"Tables should have primary keys." I wish others believed/thought that way, because I see a lot of tables with no keys of any kind, let alone have a primary key.
Kindest Regards, Rod Connect with me on LinkedIn.
May 24, 2016 at 9:51 am
quackhandle1975 (5/23/2016)
Kindest Regards, Rod Connect with me on LinkedIn.
May 24, 2016 at 9:35 am
I've been added to the db_owner role in that database. It's our understanding that would be more than sufficient in order to make it possible for me to debug stored...
Kindest Regards, Rod Connect with me on LinkedIn.
May 23, 2016 at 3:53 pm
As a developer who was part of a team in the past that liberally hard-coded the 'sa' account and its password in lots of applications and all reports, I've got...
Kindest Regards, Rod Connect with me on LinkedIn.
May 23, 2016 at 8:43 am
johnwalker10 (5/20/2016)
The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
to fix this error create a new database role
CREATE ROLE db_executor;
then...
Kindest Regards, Rod Connect with me on LinkedIn.
May 22, 2016 at 7:19 am
Thom A (5/20/2016)
Kindest Regards, Rod Connect with me on LinkedIn.
May 20, 2016 at 11:01 am
drew.allen (5/19/2016)
Rod at work (5/19/2016)
Kindest Regards, Rod Connect with me on LinkedIn.
May 20, 2016 at 8:17 am
Just thought of something else to add to this. Years ago I was working with some other report generating product (I can't remember what it was now), but I believe...
Kindest Regards, Rod Connect with me on LinkedIn.
May 19, 2016 at 1:24 pm
Yes Lynn, it does make sense. Thanks!
Kindest Regards, Rod Connect with me on LinkedIn.
May 19, 2016 at 11:45 am
Lynn Pettis (5/19/2016)
d e c l a r e -- spaced to allow posted from...
Kindest Regards, Rod Connect with me on LinkedIn.
May 19, 2016 at 10:49 am
Viewing 15 posts - 1,231 through 1,245 (of 1,970 total)