Saving Changes is not Permitted
Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the … Read more
Category : MS SQL Server
Cannot find either column “dbo”…or the name is ambiguous
“Cannot find either column “dbo” or the user-defined function or aggregate “dbo.fnycsoftware”, or the name is ambiguous.” If you are absolutely sure that you do not have have another function with that name and the … Read more
Minutes Difference Same Day (T-SQL)
// Get a time in the format : 8:00 AM // Returns the minute difference in integer using the current time // (only works for the same day but you can modify to work for … Read more
Add a Mysql as a Linked Server
The other day I got a request to migrate some data from Mssql to Mysql. I am like ok fine, I will just use SSIS and it will take me a second. This second led … Read more
T-SQL Transaction Timeout Error (SQL Server Management Studio)
In SQL Server Management Studio, if you are unable to modify a large database schema due to timeout error, you might need to increase the “transaction timeout” flag. Go to tools -> Options -> Designer and modify … Read more