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,404 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,404 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,743 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,193 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,176 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,010 reads
Finding database creation time is simple if database has not been detached from server. You can find database creation time...
2013-02-19
754 reads
SQL Server error logs can fill up quickly, and when you are troubleshooting something you may need to go through...
2013-02-08
851 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,708 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,468 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,348 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON INSERT dbo.TravelLog ( TravelLogID, CityID, StartDate, EndDate ) VALUES (25, 5, '2025-09-12', '2025-09-17') SET IDENTITY_INSERT dbo.TravelLog OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers