Viewing 15 posts - 2,341 through 2,355 (of 8,760 total)
Can you please post the table ddl and sample data?
😎
February 14, 2017 at 6:20 am
Don't think you can supress this message, do you have VSS (Volume Shadowcopy Service) on the DB volumes?
😎
February 14, 2017 at 2:12 am
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
Viewing 15 posts - 2,341 through 2,355 (of 8,760 total)