![No Picture](http://dataeasy123.com/wp-content/themes/mh-magazine/images/placeholder-medium.png)
Compare DB Objects Between two DBs
I had created a script that merges two DBs together creating, in a sense, my won DB replication process. You’ll find those scripts in this website. In any case, I needed a script to verify […]
I had created a script that merges two DBs together creating, in a sense, my won DB replication process. You’ll find those scripts in this website. In any case, I needed a script to verify […]
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 […]
— this turns on advanced options and is needed to configure xp_cmdshell sp_configure ‘show advanced options’, ‘1’ RECONFIGURE — this enables xp_cmdshell sp_configure ‘xp_cmdshell’, ‘1’ RECONFIGURE
Copyright © 2024 | MH Magazine WordPress Theme by MH Themes