Viewing 15 posts - 1 through 15 (of 1,080 total)
You will need to perform a manual forced failover on the 3rd DR replica. Have a read here , but basically you will need to failover choosing with or...
July 10, 2018 at 10:40 pm
Yes, with Basic Availability Groups you can only have 1 x database and IP assigned per BAG. If you applications needs 1 x connection string/listener name, BAGs won't work for...
July 10, 2018 at 10:34 pm
Your issue is that the Date supplied '0001-01-01' results in out of range error, as it is less than the minimum DATE value accepted. Minimum Date should be DECLARE...
July 9, 2018 at 10:44 pm
The answers did not satisfy the options. If you chose the "Classic deployment" approach, the answer could have been Azure Resource Groups focused and be wrong anyway.
July 5, 2018 at 11:23 pm
You could make use of WMI query and alerting by starting sp_who2 embedded in a SQL Agent job. Just modify the threshold duration and utilization load percentage as required. After...
July 4, 2018 at 10:38 pm
When I copy and paste your post in normal notepad:
and SSMS:Have you played with regional settings and Language on the OS level? (stab in...
July 4, 2018 at 3:55 am
what roles is this group a member of?
My account is in the BUILTIN\Users Windows Group. This group has not been assigned any server roles.
July 4, 2018 at 3:45 am
run the following to review your server permissions:SELECT pr.principal_id, pr.name, pr.type_desc, pe.state_desc, pe.permission_name FROM sys.server_principals AS pr JOIN sys.server_permissions AS pe ON pe.grantee_principal_id...
July 4, 2018 at 3:15 am
Nice question, thanks Steve
July 1, 2018 at 10:30 pm
Yes, use CONVERT(VARCHAR(5),TimeOfVisit,108)
June 28, 2018 at 4:35 am
Unsure which column you want the time only in your query, but add or replace with cast(TimeOfVisit as TIME) This will give you hh:mm:ss.nnnnn
cast(TimeOfVisit as TIME)
June 28, 2018 at 3:23 am
10GB is the limit for your data file. If you have multiple data files, the limit applies to the collective sizing, so you can not have 2 x 10GB data...
June 28, 2018 at 3:17 am
Agree with you Japie, although I think there should be a function to override truncation on normal inserts. If I understand Steve correct, we'd like something similar to SSIS, to...
June 28, 2018 at 2:59 am
SQL Server Express does not provide the functionality to create maintenance plans, or schedule them. Please familiarize yourself with the limitations of the Editions here
June 28, 2018 at 2:50 am
You can use Ola's scripts, with Windows Task Scheduler:
SQL Server Express has no SQL...
June 28, 2018 at 2:38 am