session limiting for a particular user or for all users

Question

session limiting for a particular user or for all users

sql-noob

SSC-Addicted

Points: 437
More actions
August 7, 2012 at 2:42 am

#259715

how to limit a session for a user for 30 minutes after which he automatically gets disconnected and has to connect again?????

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

sql-noob (8/7/2012)
how to limit a session for a user for 30 minutes after which he automatically gets disconnected and has to connect again?????

Are you talking about an IIS session or a sql connection?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lowell SSC Guru Points: 323518 More actions · Answer 2

sql-noob (8/7/2012)
how to limit a session for a user for 30 minutes after which he automatically gets disconnected and has to connect again?????

also are you looking for session time outs, where they are IDLE for 30 minutes and you want to drop them?

or do you want a 30 minute hard limit? what if someone is hard at work at the 29 minute mark? would you want them booted off?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!