Viewing 15 posts - 1,201 through 1,215 (of 1,941 total)
NotaSQLperson (5/26/2016)
May 27, 2016 at 8:47 am
Recombinant (5/27/2016)
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?
May 26, 2016 at 12:26 pm
Wayne West (5/26/2016)
May 26, 2016 at 8:20 am
Stefan LG (5/26/2016)
I always use Herzberg’s two-factor theory as a starting point...
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...
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.
May 24, 2016 at 9:51 am
quackhandle1975 (5/23/2016)
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...
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...
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...
May 22, 2016 at 7:19 am
Thom A (5/20/2016)
May 20, 2016 at 11:01 am
drew.allen (5/19/2016)
Rod at work (5/19/2016)
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...
May 19, 2016 at 1:24 pm
Yes Lynn, it does make sense. Thanks!
May 19, 2016 at 11:45 am
Viewing 15 posts - 1,201 through 1,215 (of 1,941 total)