OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.
2017-09-22 (first published: 2016-03-22)
15,609 reads
With the Konesans File Watcher Task for SSIS we can import files as soon as they arrive.
2014-10-10 (first published: 2012-08-13)
18,881 reads
With the WMI Event Watcher Task in SSIS we can import files as soon as they arrive.
2014-10-03 (first published: 2012-07-02)
27,139 reads
Learn how you can process data files with SSIS as soon as they arrive using the Script Task.
2014-09-01 (first published: 2012-10-25)
45,526 reads
Implement Loginless Database Users to maintain data security and preserve interface when dynamic SQL is being used within a stored procedure.
2013-09-10
7,324 reads
Identify orphaned Database Users and differentiate them from "Loginless" Database Users.
2013-05-13
3,112 reads
Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.
2012-11-20
8,718 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers