Viewing 15 posts - 1 through 15 (of 81 total)
Not sure I follow the value in using an RDL locally as opposed to converting to an RDLC and using the ReportViewer. In fact, I think there's very little if...
January 18, 2021 at 8:19 pm
I don't think you understand. When you have Visual Studio 2017 or later, there is no standalone install for SSDT. We'll try to run the VS installer and select SSDT...
November 1, 2019 at 3:39 pm
He's already reinstalled SSMS and he uses Visual Studio 2017, so there's no standalone SSDT on his machine.
November 1, 2019 at 3:28 pm
Thanks for the quick response! That looks like the root of the problem, so I've made a change there and I'll be tracking this over the next few days.
October 4, 2019 at 6:27 pm
Also, group membership can be nested and xp_logininfo should be executed for each group you get for AD\user:
exec xp_logininfo 'AD\group','members'
I'm not seeing that xp_logininfo will show...
August 5, 2019 at 3:12 pm
If I'm following you answer correctly, you're saying that the application password is not using integrated security at all, so this is a separate password that has to be maintained.
I...
July 31, 2019 at 6:21 pm
Can you provide more details of what you are trying to accomplish, so we can possibly provide some better direction?
FWIW, we have Production, Test, and Dev environments...
July 3, 2019 at 2:49 pm
Nope. You have not specified anything in the command to actually grant execute permissions on. But, it will complete without error. This is the books online entry: https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql?view=sql-server-2017...
July 2, 2019 at 7:18 pm
YB, assume that myuser represents an AD group. I'm simplifying my post to get at the root issue. I totally get what you're saying.
July 2, 2019 at 6:50 pm
Hmmmm. I have GRANT EXECUTE TO myuser, so I'm assuming that gives myuser rights to execute any sproc in the database and thus allows rights to use OBJECT_ID and OBJECT_DEFINITION...
July 2, 2019 at 6:47 pm
More info - if I do the following, I no longer get an error on the GRANT SELECT ON sys.procedures:
USE [master]
GRANT CONNECT TO myuser
GO
However, I still get errors on the...
July 2, 2019 at 4:07 pm
Thanks, I actually had GRANT CONNECT as well, but only in the [master] database. I didn't have it for each database.
April 18, 2019 at 5:38 pm
sqlpro - Monday, January 18, 2016 12:46 PMbut compression requires enterprise version of sql server, right?
Since SQL Server 2016sp1, compression is available...
October 19, 2018 at 7:18 am
FYI, I also posted this question on StackExchange and got a nice example of using Extended Events to give a possible solution:
https://dba.stackexchange.com/questions/207684/where-is-this-query-coming-from/207779?noredirect=1#comment407134_207779
May 29, 2018 at 9:54 am
Viewing 15 posts - 1 through 15 (of 81 total)