Viewing 15 posts - 2,041 through 2,055 (of 8,760 total)
Thanks for the info. I'm fairly skilled with SQL but fairly new to SQL Server...
July 6, 2017 at 4:54 am
July 6, 2017 at 4:46 am
Does SQL Server provide a simple easy way to test stored procedures and functions? ...
July 6, 2017 at 3:49 am
My normal approach for this is to shred the XML using XQuery in SQL Server, much more flexible than SSIS
😎
Don't use much 3rd party tools so unfortunately...
July 6, 2017 at 3:03 am
July 6, 2017 at 2:17 am
Is there any way the performance can be improved if a XML input variable is...
July 6, 2017 at 1:38 am
Looks to me like someone is trying to use the old "DTS Password" vulnerability or later variants thereof
😎
Recommend that you remove those attachments immediately!
July 5, 2017 at 4:27 am
Can you post the errors from the log please?
😎
July 5, 2017 at 12:10 am
June 29, 2017 at 9:18 am
June 29, 2017 at 2:47 am
I have a number of DFT in a For Each Loop, I have created variables...
June 28, 2017 at 1:57 am
Note that a stored procedure retains the SET QUOTED_IDENTIFIER settings from when it is created, here is a quick example
😎SET QUOTED_IDENTIFIER OFF;
GO
IF OBJECT_ID(N'dbo.SP_TEST_QI') IS...
June 27, 2017 at 6:31 am
Using excutuion...
June 27, 2017 at 6:05 am
Quick question, have you considered using the OUTPUT from the delete for the archive insert?
😎
June 27, 2017 at 5:48 am
Viewing 15 posts - 2,041 through 2,055 (of 8,760 total)