Determining The Number Of Active Users Logged Into A SQL Server Database

Apr 20, 2006

How does one Determine the number of Active users logged into a SQL Server Database?

I want to use the info to control concurrent licensing for my Application

View 6 Replies


ADVERTISEMENT

Getting Number Of Logged On Users To Server

Jul 20, 2005

SQL Server 2000 - MSDE 2000Is there a way to get the number of current users logged into a SQL 2000 Server (also MSDE)? Cant be distinct users as most users are logged into the database using the same login.-- Tim Morrison--------------------------------------------------------------------------------Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.http://www.vehiclewebstudio.com

View 4 Replies View Related

Added Users To A Logged Shipped Database

Dec 20, 2007

I have 2 sql server 2000 database that participate in log shipping.Server A is the source database, which log ships to a database onServer B. The database on Server B is in a warm stand by/read onlymode. Is there a way that I can add users to the database on ServerB, without having to add the users to the database in server A? I amtrying to use the database on Server B as a reporting only databaseand add more users to have permissions to run reports.Please let me know if anyone has any suggestions. Thank you.

View 2 Replies View Related

SQL Security :: Users Logged In Server

Jun 12, 2015

We wanted to know list of  users who had logged into the SQL Server from last 10 to 30 days.

View 2 Replies View Related

Security Report - List Of All Active Users In Database With Their Privileges

Aug 28, 2014

I am looking to write a script that would give the list of all active users in a database with their privileges.

Sample would look something like this.

Login User Schema IsdbOwner canWrite canRead
xyz xyz dbo N Y Y

View 2 Replies View Related

Users Logged In

Sep 28, 2007

Is there a way in 2005 to tell what user is logged into what databaseon the SQL Server?thanks,Scott

View 3 Replies View Related

SQL Users Logged In Report

Feb 15, 2006

Hi

I need to get a report that tells me the no. of users logged on to the SQL Server (this has to be an hourly report)

Will this do



WHILE 1=1
BEGIN
Select Hostname,getdate() from sysprocesses
WAITFOR DELAY '00:59:00'
END
GO


Will it have any bad affects on the SQL Server


Or can someone plz let me knw how to get that


Thanks

View 3 Replies View Related

How To Check How Many Users Logged In

Dec 15, 2007

Hi,
I have a question regarding sqlserver 2005
I am working on a production server.
how to check how many users are logged in currently in sqlserver and
also how to check the session info and memory usage by a paticular user......

View 1 Replies View Related

How To Determine If The Logged On User Is A Member Of An Active Directory Security Group?

Aug 7, 2007



We are using Windows authenication within our system, and I was wondering how it would be possible to determine if the user conected to the SQL SERVER instance was a member of a particular active directory security group?

Thanks.

View 3 Replies View Related

Finding Users Logged In To A Session

Jan 6, 2005

I have a program which will show you users logged into a session. It's designed in MS Access and will also record citrix/terminal users. If you would like a copy of the program, download the attachment or email me at paulk@weccusa.org.

Paul Kohn
Database Administrator

View 12 Replies View Related

Maximum Users Logged In Sql Express

Feb 17, 2007

we're planning to use sql express as our database server in our office. the database will consist of accounting, purchasing, marketing, sales, inventory, production and hrd tables. 80-100 users will use the system simultaneously in adding, editing, deleting, reports.
i need some advice on the following:
1. maximum users that can log on to the database simultaneously?
2. maximum size of the database?

tnx

View 7 Replies View Related

Query To Show Only Users Who Logged On In Past 6 M

Feb 20, 2006

Hi All

I have built this query :

Select position, SubsidiaryName
from position
Where SubsidiaryName in ('country1','country2')
and position not like('testuser_%')
and position not like ('Inactive_%')
and position not like('olduser_%');

However when I run it, the result more accounts in country 1 than expected. I think it could be inactive users who have not logged into this system for 6 months or more. How can I build a query that incorporates my original query + shows only users who logged into the past 6 months ?

View 2 Replies View Related

Accessing Users && Members In Active Directory Via Linked Server

Mar 24, 2006

Hi,

I'm trying to extract all the users and their membership to groups, and the membership of groups to groups from active directory though a link to server.

I can get the users. I can get the groups.... individually.

I can't get the info of what user is a member of or who are members of a group.

Anyone know how to do this or am I going to have to right a vb app? (Anyone already got the code...)

I want to load this data into tables for reporting in my Data Warehouse.

Cheers

Chris

View 1 Replies View Related

SQL Security :: Maximum Number Of Users That Could Be Created For Any Database

Jun 16, 2015

Is there any maximum cap on the number of users that could be created in a given database of MS-SQL Server?

View 4 Replies View Related

How To Check Number Of Active Connections In SQL Server?

Jan 23, 2002

Hi All

How to check number of active connections ?
I know two ways of doing it ..

1. run sp_who2

2. in Current Activity in Enterprise Manager ..

If what ever number I am seeing is the Active Number of Connections ..then

I am facing a problem here ..

In My serevr I have 75 Users licenses are configured for Per server option ..
Through a Java aplication when Developer tried to capture any SQL server Connection it says following error ..

Details :
[MERANT][SQLServer JDBC Driver][SQLServer]Login failed. The maximum simultaneous user count of 75 licenses for this 'Standard Edition' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version.

If I see from Sp_who2 and Current Activity , I can see only 37 Connections ...?

Why is so .. If I am having 75 configured and 37 live in sp_who2 ..why I am getting that error message ?

Is there other way to see Actual Number of Connections made to server ?

Sujit Kandi
1 860 520 7454

View 1 Replies View Related

Max. Number Od Users In SQL Server

Dec 19, 2006

How many users can access to SQL server at the same time with web aplicationwritten in C# 2005? What if my database is 1GB and 1000 people access at 1second - some simple query. My web hosting acc will behttp://www.webhost4life.com or something simmilar!

View 2 Replies View Related

Number Of Simultaneous Users/connections On SQL Server

Mar 30, 2001

Hi,

could somebody please let me know what is the maximum number of simultaneous users/connection per single SQL Server 7.0 box? Licenses are not the issue here, rather the number of physical connections supported before another server needs to be purchased.

Another variation of this question would be what's the highest number of databases that 7can be created on SQL 7.0 server and what is the highest number of physical connections supported per database? Again, licenses are not the issue. Thanks a lot in advance.

View 2 Replies View Related

SQL Server 2005 Workgroup - Number Of Users Limit?

May 7, 2008

Does SQL Server 2005 Workgroup Edition have a limit to the number of user logins I can make?

View 1 Replies View Related

Active Directory + List Users

Oct 25, 2007

I neet save user login form active direcotry to databases. How I can make that?

View 1 Replies View Related

Finding Active Users From Sysprocesses

Jul 20, 2005

I am trying to find a select on sysprocesses that would list all the activelogins. An active login is a login that has a TSQL statment being executedon the server,This didnt work to well! Any ideas. Thanks in advance.select sp.loginame,-- more columnsfrom master..sysprocesses spwhere sp.status not in ('sleeping','background' )order by 1

View 2 Replies View Related

How To Query Active Users - Where Is This Info Stored ???

Jul 25, 2001

I know how to look at active users from Enterprise Manager, but how can I query out the information - what table is that info stored in ??? I don't want a list of all the logins, I just want the list of active users....

Help... thanks in advance,
Nancy

View 2 Replies View Related

Transact SQL :: Loop - How To Get Data For Each Of Active Users

Jun 9, 2015

My insert statement for #Data - I only need to process each @EmployeeID one time, which is why I thought a loop would be sufficient, but I let this process run for 2 hrs and it still had not completed, so I feel I must have set-up something incorrectly!

This is my syntax, I am creating a table of active users, then wanting to get data for each of those active users.  But only get the data for each active user 1 time.

Declare @EmployeeID varchar(50)
CREATE TABLE #ActiveUsers
(
ID INT IDENTITY NOT NULL
,EmployeeID varchar(50)
,processed int
)
Create Table #Data

[Code] ....

View 5 Replies View Related

SQL Server 2012 :: Manage Concurrency When Users Need To Create Invoice Number

May 31, 2014

I have a db to manage the creation of invoice number designed for a web application.

My problem is how to manage the concurrency when the users need to create an invoice number.

View 9 Replies View Related

SQL Server Admin 2014 :: Practical Upper Limit On Number Of DB Users

Sep 9, 2015

Our development team wanted to create a database user for each application user in the application and use these for granular data access control, which at first, sounded like a good idea but our initial testing ran into some interesting results.

Our target user base was about 15 million users with an estimated 1% concurrency rate, and finding no MS documentation on an upper limit to the number of users a database can have we began some load testing to see how the database performed. In the hundreds of thousands of users range our test database had a hard time performing well under light loads (even without any concurrent connections).

When we purged the users and reverted back to just a handful of service accounts, performance went back to "normal" under the same loads. I began to wonder if this is a situation where throwing more hardware at the problem would overcome the issue or if there is a practical upper limit to the number of users a single database can handle well.

(There were of course other cons to this arrangement and I certainly was never going to expand the users tree in the object explorer for a database like this, but we thought it a solution worth investigating.)

What is the largest number of users any of you have had in a single database?

View 3 Replies View Related

ADS Opens Folder On Users PC When Active Sync Connects

May 12, 2008

Is there anyway to disable this functionality?

View 7 Replies View Related

Advice On Security Model For XML Web Services For Many Users In Active Directory Role

Feb 21, 2006

I am working on the security model for an application that will be used by 100s of users with a dedicated SQL 2005 database for this application and access via SQL XML Web Services.

The client has asked to make it "open" during alpha testing such that anyone can access the web services without having to set them up first. Is there a way to do this? The best I can figure is to use mixed mode security and hard code a login and password. Any method using Windows authentication would require that I add every user at a minimum to the database.

In production, all users will have an active directory role specified that determines if they should have access to the web services or not. However, it is my understanding that to use Windows authentication, I would still need to add each individual user at a minimum as a Login to the SQL Server, and under best practices also as database users with permissions granted to the endpoint.

Am I correct in the above, or is there a more efficient way to achieve these results?

Thanks

-L

View 1 Replies View Related

Number Of Active Connections

Sep 20, 2005

Hi.
I have to buy a license for MS SQL Server 2000 and I need to know how many active connections I will need.
I could try by running the application with multiple users and see how many connections there are.

The questions is: How can I know the number of active connections to the Server?

Thanks!

View 2 Replies View Related

SQL Server 2012 :: Query To Count How Many Sessions Are Active And Remain Active Per Hour

Jan 22, 2015

I have a table with the following columns employeeSessionID, OpDate, OpHour, sessionStartTime, sessionCloseTime. I need to see how many users remain active per hour. I can calculate how many logged in per hour, but I am stumped on how to count how many are active per hour. I have a single table that stores login data. I have created a query that pulls out the only the data needed from the table into a temp table using this query. Also note it is possible that the sessionCloseTime is null if the device has not been logged out this would need to be counted a active.

TABLE NAME #empSessionLog Contains the time stamp data OpDate, sessionStartTime and sessionCloseTime.
OpDatesessionStartTimesessionCloseTime
2015-01-202015-01-20 14:32:59.1302015-01-20 14:33:14.6299166
2015-01-202015-01-20 06:58:33.7302015-01-20 15:27:16.9133442
2015-01-202015-01-20 09:56:22.8402015-01-20 17:56:29.7555853
2015-01-202015-01-20 05:59:18.6132015-01-20 14:05:19.0426707

[code]....

can see how many sessions logged in per hour with the following statement:

SELECT
opDate,
FORMAT(DATEPART(HOUR, sessionStartTime), '00') AS opHour,
Count(*) AS Total
FROM #empSessionLog
Group BY opDate, FORMAT(DATEPART(HOUR, sessionStartTime), '00')
Order BY opDate, FORMAT(DATEPART(HOUR, sessionStartTime), '00') ASCResults:
opDateopHourTotal
2015-01-20041

[code]....

Where I am stuck is how do I count the sessions that remain active per hour until the session is closed with the sessionCloseTime.

View 5 Replies View Related

CHECK ACTIVE SQL SERVER DATABASE

Mar 14, 2008

HOW DO WE CHECK ACTIVE SQL SERVER DATABASE?
Please advice!

View 4 Replies View Related

Active/Active SQL Server Clustering With Multiple Instances

May 12, 2008

Hi

I am newbie in SQL Clustering. I have set up a Windows Server Cluster with 2 nodes and am having the following problem with Physical Disk resource for cluster groups:

My Default Cluster Group (named Cluster Group) has IP Address, Network Name, Physical Disk and MSDTC resources. In addition to that my Default SQL Server instance resources are also in this group. I had this initial set up for Active/Passive mode.

Now I am trying to set up a SQL Cluster in Active/Active mode. For this I have to install another instance of SQL Server in the existing cluster and make a separate cluster group for its resources. I made a new cluster group (SQL Instance Group) with an IP Address and a Network Name resource for this new instance but I dont have any Physical Disk resource to allocate to it. As such while installing the SQL Server Instance I get stuck when I'm asked to select the quorum disk to be used.

Is it possible to configure two quorum disks, one for each group?
What's the concept of dedicated disks resource for each sql instance in a group? Is this same as the quorum disk? If this is not a shared disk how do I configure a dedicated disk resource for my second cluster group (SQL Instance Group)?

Anyone could please help me out with this?

View 12 Replies View Related

Determining Database Size

Oct 31, 2001

Is there a system stored procedure that I can execute that will return the actual size of the database you are working with? Any information is appreciated.

View 1 Replies View Related

Determining Database Size

May 9, 2008

Forgive the easy question but I'm afraid it might be also a trick question and I'd like to hear the experts' opinion. I am using SQL Server 2005 Express edition and I know the limitation is 4GB per database. So far none of my users is anywhere near the limit but I have to be prepared for when that day finally comes. As it stands, they use a single database through a program so I have full control over it. There are no fancy backup programs on the system so no fancy recovery models and automatic shrinking can be done - data is only inserted in that database.

My question is simply how can I determine programmatically (I use ADO.Net but it can execute SQL commands just fine) the size of the database as it relates to the limitation? That is, I don't know whether it is the amount of data stored - with or without overhead, or it is simply the size of the *.mdf file (maybe together with the *.ldf file), or whether the 4GB is 4 billion bytes or 2^32 bytes - I just want the same method that the SQL Server is using so that, for example, I can bring up a warning at 90% full and lock out the user at 99% full.

I'd appreciate any insights.

Kamen

View 3 Replies View Related

Determining Is A Database Is A Subscriber

Feb 1, 2006

Hi,



can anyone tell me if there is a way to determine with SMO or RMO if a database is a subscriber when using merge replication. If only have the Server and database at this point too!!

I want to provide a small app that creates a merge publication but only if the database isn't a subscriber.

Thanks for your help

Graham

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved