Hello everyone, The important thing to remember here is that the “sorted list of tables” will change depending on whether you are either Inserting or Deleting data. I like the image used by w3resource – […]
The error is: Msg 9514, Level 16, State 1, Line 216 Xml data type is not supported in distributed queries. Remote object [Server_name].[DB_Name].dbo.[table_name]’ has xml column(s). Are you trying to query a remote DB\table which […]
I was in need of migrating a key DB (located on a fragile, never updated SQL 2008 R2) into a SQL 2016 Server hosting a “Fail over/Availability Groups Environment”). There could be no downtime given […]
I have combined a few scripts into this long one that provides the following columns: The scripts provides many uses:1) In LAB Environment, you can review which DBs have not been accessed and plan to […]
Copyright © 2024 | MH Magazine WordPress Theme by MH Themes
