You can use a Derived Column transformation task between source and destination, or you can modify SQL to cast the column as specific data type.

For example: CAST( col1...

OK, I thought he said stored procedure earlier, so scratch that.

So, you have this flat denormalized table containing nearly 100 million rows and 100+ columns. The problem is you need to report from it; performing rollups at various levels, aggregation...

If for whatever reason the extended event trace doesn't give you what you need about input parameter values, then can also implement procedure call auditing using a table and adding...

If I understand you correctly, you have a table containing a significant amount of history, much of which you believe can be archived elsewhere. You now want to know the...

Gary Varga (10/4/2016)

---

So now everyone and their grandma is going to ask us to secure their IoT lightbulb because it is going to be "their" responsibility. Legally, would it then...

When in the role of a candidate, I'll typically ask why the previous person in the position decided to leave, or why he/she was let go. It's a good one...

Perhaps the procedure you are executing is calling the other procedure. Look at the T-SQL contents to confirm. That would be my first guess.

Are you asking how to SQL query a text file?

If so, then you canuse OPENROWSET function.

https://msdn.microsoft.com/en-us/library/ms190312.aspx

jasona.work (10/3/2016)

---

...

Which, really, comes around to "why in the H*LL does my refrigerator need to be on the internet in the first place?" So I can remotely check my...

One option is to use VPN/RDP to access your PC or server from where you can use SSMS or SQLCMD.

I'm only somewhat acquainted with Oracle, enough to form an opinion without forming an attachment. In my opinion, Oracle has a lot of "junk in it's trunk" dating back to...

robert.sterbal 56890 (10/3/2016)

---

Its a balance of risks. Private VPNs were very expensive and I would bet more likely to fail than the public network.

Additionally the risks on a private network...

First I'd just like to mention that vertically partitioning across multiple tables, when there...

Also, put this all into the...