SQL Server – Saving Changes Not Permitted in Management Studio
SQL Server Management Studio does not allow you to save changes to a table which require table re-creation such as...
2013-04-09 (first published: 2013-04-01)
3,397 reads
SQL Server Management Studio does not allow you to save changes to a table which require table re-creation such as...
2013-04-09 (first published: 2013-04-01)
3,397 reads
There are different options available when you want to execute a .sql script file on a server. You can open...
2013-03-25
9,723 reads
When you create a new database in SQL Server without explicitly specifying database file locations, SQL Server created files in...
2013-03-18
2,186 reads
You can start/stop SQL Server services using Services Console or SQL Server Configuration Manager. You can also perform these operation...
2013-03-11
2,171 reads
To rename an object in SQL Server you can use sp_rename system stored procedure or you can do this via...
2013-03-04
2,002 reads
Finding database creation time is simple if database has not been detached from server. You can find database creation time...
2013-02-19
748 reads
SQL Server error logs can fill up quickly, and when you are troubleshooting something you may need to go through...
2013-02-08
843 reads
Earlier on my blog I posted about how you can attach a database using T-SQL when no log file is...
2013-01-30
2,703 reads
In SQL Server you can enable a Trace Flag at session (effective for current session only) level and global level....
2013-01-24
1,465 reads
You can use WITH CHECKSUM option to perform checksum when backup is created. When used this verifies each page for...
2013-01-15
2,347 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers