|
|
-
Marc Jellinek Commented 1 Months ago through Blogs
Rather than adding a single user (who can be deleted or removed over time), create an AD Group or a Local Group, then make the members of that group a member of the [sysadmin] server role.
This way, an AD Administrator can add an individual to the gr...
|
-
Marc Jellinek Commented 1 Months ago through Ask
I can't parse this XML into something valid.
Can you repost it, selecting the XML, and clicking on the "code" button? (the stack of 0's and 1's)...
|
-
Marc Jellinek Commented 1 Months ago through Ask
Then setting or checking the transaction isolation level within a LOGON TRIGGER should meet your needs. Any query hints will override this setting ( for example WITH (NOLOCK) ).
Does this meet your needs?...
|
-
Marc Jellinek Commented 1 Months ago through Ask
There really isn't a good way of doing this.
What you can do is set a LOGON TRIGGER that detects the transaction isolation level (by querying sys.dm_exec_sessions) and aborting (issuing a ROLLBACK) if the isolation level doesn't meet your requirement...
|
-
Marc Jellinek Commented 2 Months ago through Blogs
>> Some other packages are running on 64-bit provider too in same machine. I was getting this issue for only for one package among them
Are all the packages running under the same security context?...
|
-
Marc Jellinek Commented 2 Months ago through Blogs
The problem is you have the 32-bit provider installed, but not the 64-bit provider. By forcing the package into 32-bit mode, it's able to communicate with the provider....
|
-
Marc Jellinek Commented 2 Months ago through Blogs
@hicham4
Given that you will have a large number of respondents and large number of questions, it's probably a better idea to perform the pivot in a reporting tool like SQL Server Reporting Services (using a Tablix), Access (using a CrossTab query) o...
|
-
Marc Jellinek Commented 2 Months ago through Blogs
The solution provided really isn't appropriate for a pivot. It's more like a column expansion, like this:
SELECT [p].[seq],
CASE WHEN [p].[ItemColour] = 'Red' THEN 1 ELSE 0 END as [Red],
CASE WHEN [p].[ItemColour] = 'Blue' TH...
|
-
Marc Jellinek Commented 2 Months ago through Just Learned
Since you can no longer see any databases, can you grant permission to view/list individual databases?
After denying "view all databases", I can't see any databases other than master and tempdb. Opening a new query, I can explicitly issues "USE [Hid...
|
-
Marc Jellinek Commented 3 Months ago through Just Learned
Why wouldn't you use the Snipping Tool that ships within Windows? This way you can do screen capture from within the RDP session, outside the RDP session, or both....
|