Determining if it's a SQL login, Windows Login, or Windows group
A recent question on the forums asked how to determine if a database
user was a Windows user or group and...
2006-04-06
3,886 reads
A recent question on the forums asked how to determine if a database
user was a Windows user or group and...
2006-04-06
3,886 reads
I've been dealing with Kerberos delegation setup with respect to
Microsoft's CRM 3.0 product and while the process isn't difficult, if
you...
2006-04-05
2,140 reads
The March/April 2006 edition of SQL Server Standard magazine is now
available. This issue focuses on Transact-SQL for SQL Server 2005.
Though...
2006-04-03
1,507 reads
Those of us in technology are very, very used to automated systems,
batch jobs, etc., all which run without human interaction...
2006-03-29
1,350 reads
If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...
2006-03-28
1,553 reads
This is a follow-on to my post What are the actual rights?
First and foremost, I want to include membership in...
2006-03-14
1,413 reads
One of the things I've started to work on are some scripts to quickly
be able to pull what a user's...
2006-03-14
1,441 reads
I received a copy of Professional SQL Server 2005 Integration Services
a few weeks back from Kathi. Because of illness and...
2006-03-13
1,478 reads
Catching up on recent updates for tools I've looked at and/or recommended.
SQL Server Tools:
PromptSQL is now up to version 1.4....
2006-03-13
1,562 reads
I think anyone who posts actively in the various on-line forums for
Microsoft products (such as SSC.com) hopes one day to...
2006-02-23
1,368 reads
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...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
Comments posted to this topic are about the item Oracle Performance Tuning: Practical Techniques...
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