Viewing 15 posts - 1 through 15 (of 431 total)
Thanks Frederico - I tried the below and getting the error below.
select Convert(datetime,dr_value,101) as Converted_Date from "users"."dr_tracking";
There was an error reading the results of the SQL statement.
The displayed results may...
June 8, 2022 at 10:06 pm
I was trying something like this below..
select Convert(Varchar(100),dr_value,103) as Converted_Date from dr_tracking ;
June 8, 2022 at 9:29 pm
You can only do that if you install as a default instance.
looks like you installed as named instance, therefore connection will be servername\instanceName
May 6, 2022 at 1:47 pm
Thank you Jeff, this is helpful.
May 2, 2022 at 6:32 pm
Hi Jeff - quick question
I was trying to replace 'Green' color with color code #90EE90....but it's not working.....any idea what I am doing wrong?
(
SELECT td = CONCAT('~bgcolor="'
,CASE mirroring_state_desc
WHEN 'SYNCHRONIZED' THEN...
May 2, 2022 at 1:16 pm
Thank you Jeff, this is working as I expected.
Really appreciate taking the time out of your busy life to help out.
April 25, 2022 at 3:00 pm
Hi Jeff - just checking to see if you got a chance to test it.
April 21, 2022 at 4:04 pm
Thanks Jeff for the reply.
--Working SP to send email for Database mirroring report using LinkedServer OPENQUERY
USE [master]
GO
/****** Object: StoredProcedure [dbo].[Mirroring_Status] Script Date: 4/13/2022...
April 19, 2022 at 1:37 pm
Attached the script in .docx type.
April 14, 2022 at 8:40 pm
select @@version - Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: )
Also, attached the script.
Thanks in advance.
April 14, 2022 at 8:35 pm
January 15, 2018 at 1:06 pm
January 10, 2018 at 10:14 pm
August 30, 2017 at 1:32 pm
Thanks Sue.
So, you are saying a user with securityadmin server role and db_securityadmin db role is not enough to create/add a permission to another user without db_accessadmin privilege...
August 30, 2017 at 1:13 pm
March 8, 2017 at 2:16 pm
Viewing 15 posts - 1 through 15 (of 431 total)