Viewing 15 posts - 736 through 750 (of 6,400 total)
The MSC is on the SQL SERVER itself not your client machine as that's the configuration manager for the services which you wont have locally.
September 22, 2021 at 6:40 am
How does the link not give you the information you need?
The link states that for SSRS 2019 you can use SQL 2012 or above as the platform to host the...
September 21, 2021 at 6:54 am
If you have a database in a logshipping configuration you must stop all other log backups from happening, otherwise you break the log chain and logshipping fails.
If you are using...
September 20, 2021 at 6:57 am
Be careful using undocumented procedures like xp_copyfile, Microsoft can and will change them and the behaviour resulting in breaking changes for you.
You will be best to write your own CLR...
September 14, 2021 at 4:56 pm
In the database, query sys.database_permissions and filter on the role id, join that back to sys.objects and you got what you need.
September 14, 2021 at 3:58 pm
Quickest would be to use DBATools and the get-dbauserpermission function to extract the detail your after.
Otherwise your into querying the DMVs like server_permissions, database_permissions (in each DB), roles, role_members and...
September 14, 2021 at 3:19 pm
Yeah you will get results in varying order depending which dns server responds to the query.
SSRS does support multisubnetfailover=true in the connection string.
that is the official stance from Microsoft, if...
September 13, 2021 at 7:39 pm
if you do an nslookup to the listener do you get all the IPs back?
if so you need to either disable registeraipproviders
or the recommended approach, change your applications to use...
September 13, 2021 at 7:19 pm
As its a existence check, you should just be able to remove the where exists and switch it to an inner join instead, you have the syntax and the joining...
September 13, 2021 at 12:55 pm
Disk maintenance has to be done on a machine which is powered down, you cannot add/delete/modify disks on a running VM.
Can you power down the machine and try again?
September 13, 2021 at 12:53 pm
There is nothing to force the keyword "WITH ENCRYPTION", if you want every backup to be encrypted look at TDE instead, that will ensure it is encrypted even if you...
September 13, 2021 at 12:51 pm
Patch then async manual failover replica
Patch whatever is then the secondary in the WSFC
Failover to secondary
Patch the remaining node.
If you want to failback afterwards do so, but not important
September 10, 2021 at 12:57 pm
Please take a read through this link, it defines the usual etiquette on how to post code, as many people wont download a file from an unknown user or take...
September 10, 2021 at 6:53 am
Can you not go SQL 2019, TDE became a Standard edition or above feature in 2019, will save you a chunk of change if you can.
I am no licensing expert,...
September 9, 2021 at 7:18 am
You still haven't described the problem you are facing.
Do you have existing none unicode data that must be convert to Japanese?
Do you now have a requirement to store unicode and...
September 8, 2021 at 3:16 pm
Viewing 15 posts - 736 through 750 (of 6,400 total)