Viewing 15 posts - 2,341 through 2,355 (of 8,753 total)
Something like this maybe?
😎
SELECT
PROP.DATA.value('(@Name)[1]','VARCHAR(100)')
FROM @DTSXML.nodes('//Property') AS PROP(DATA)
You will have to add either the namespace declaration or a namespace wildcard...
February 13, 2017 at 7:24 am
My guess is that the application / package renames the actual backup to DoNotDeleteThisFile.txt
😎
February 13, 2017 at 5:17 am
I have seen this before, IIRC, I bounced the Full Text Services with "net stop xxx" and "net start xxx" to resolve it.
😎
You might want to...
February 13, 2017 at 2:28 am
February 12, 2017 at 4:31 pm
I am soon going to be migrating 300+ databases off of are old sql...
February 12, 2017 at 3:09 am
February 10, 2017 at 8:56 am
February 10, 2017 at 8:53 am
Judy Why - Friday, February 10, 2017 7:39 AMthe server is dedicated server, no SSRS, no SSIS, no SSAS running.
Normally leave between...
February 10, 2017 at 7:56 am
February 10, 2017 at 7:34 am
February 10, 2017 at 7:31 am
Am I correct in thinking that sys.dm_exec_query_stats only includes queries that completed sucessfully? If...
February 10, 2017 at 7:23 am
February 10, 2017 at 7:20 am
Anything in the default trace or sys.dm_exec_requests when this is happening?
😎
February 10, 2017 at 7:15 am
poornima.s_pdi - Thursday, February 9, 2017 3:02 AMThanks Eirikur Eiriksson.
I got my result..
Really this forum is very helpful..Regards,
Poornima
You are very welcome.
😎
February 10, 2017 at 5:18 am
For fun, a variation of Chris's solution
😎
DECLARE @BINID VARBINARY(16) = NEWID();
;WITH BINARY_STUFF(DHASH,BINDATA,BINID)
AS
(
SELECT CONVERT(CHAR(64),HASHBYTES('SHA2_512',CONVERT(VARCHAR(36),@BINID,0)),2),CONVERT(VARCHAR(36),@BINID,0),@BINID UNION ALL
SELECT CONVERT(CHAR(64),HASHBYTES('SHA2_512',CONVERT(VARCHAR(36),@BINID,1)),2),CONVERT(VARCHAR(36),@BINID,1),@BINID UNION ALL
February 10, 2017 at 3:16 am
Viewing 15 posts - 2,341 through 2,355 (of 8,753 total)