Issue: SQL Server 2016 would not send mail on a new server migration to Windows Server 2016 Solution: By default, Windows Server 2016 installs .net framework 4.7 The database mail feature needs .Net 3.5 Install this windows feature and this issue gets resolved.
“A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. SQL Server 2014 helps user to isolate their database from the instance in 4 ways. Much of the metadata that describes a database is maintained in the database. (In addition to, or […]
Below are reference links to Microsoft documentation web pages listing deprecated database features from SQL 2005 to SQL 2014…. 2005 http://msdn.microsoft.com/en-us/library/ms143729(v=sql.90).aspx 2008 http://msdn.microsoft.com/en-us/library/ms143729(v=sql.100).aspx 2012 http://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx 2014 http://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx
You cant restore a database backwards from SQL Server 2008 to a SQL 2005 Instance. One trick you can use is to script the entire database, and ensure you select in the advanced options as shown below, SQL 2005. Then run the script at the destination SQL 2005 instance. Remember to change the database file […]
Issue: A restored database from one instance to the other keeps showing below when attempting to say, alter a stored procedure. The database owner SID recorded in the master database differs from the database owner SID recorded in database Solution applied: Assuming XYZ is the name of the database and contosoadmin is the name of […]
Sample T-SQL Code for creating a database snapshot. use AdventureWorks2012 go sp_helpfile — used to get the logical database name needed for below CREATE DATABASE AWSnapshot ON ( NAME = ‘AdventureWorks2012_Data’, FILENAME=’d:tlogAWSnapshot.ss’ ) AS SNAPSHOT OF AdventureWorks2012; –using it USE AWSnapshot; GO SELECT * FROM Sales.SalesOrderDetail WHERE ProductID = 53; –reverting from snapshot RESTORE DATABASE […]