SQL Server 2000 - MSDE 2000
Is 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
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
We wanted to know list of  users who had logged into the SQL Server from last 10 to 30 days.
View 2 Replies View RelatedIs there a way in 2005 to tell what user is logged into what databaseon the SQL Server?thanks,Scott
View 3 Replies View RelatedHi
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
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......
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
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
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 ?
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 RelatedHow 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 RelatedHi,
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.
Does SQL Server 2005 Workgroup Edition have a limit to the number of user logins I can make?
View 1 Replies View RelatedI 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.
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?
Quick question, is there a limitation on the number of users that can get into SQL server at one time? Say 1500 or 2000 users? If not, I wonder how many users can actually cause the performance of the server to have a significant drop.
Thanks
SHK
when i see the number of users on my local connection. It says 4 and another DB says 12. But nobody is connected to these DB but me. Why is it showing 4 and 12?
View 1 Replies View RelatedHello,
There was a 5 concurrent user limitation in MSDE (the version prior to SQL Express). Does that same limitation exist with SQL Express 2005?
Thanks.
Hi,
Can somebody let me know how many (maxi) no of users can be created to deal with MSDERelA ?
With kind regards,
Ashfaque
I need a small SQL server for up to 10 users. If I understand the EULAs and FAQs correctly, there is no limit on the number of users imposed by the SQL Server 2005 Express license. If so, then the number of users is only limited by the OS's license so all I need is SQL Server 2005 Express (free), Windows XP Pro (10 users limit) and no CALs for either Windows or SQL Server.
I'd be thankful if someone could verify this.
I'm looking to migrate a number of sql users to windows authentication, so I want a list of each login and for each login a list of all their roles. My plan is to write 2 WHILE loops that will go through each login and for each login the list of roles.The first Row_Number is not returning the order that I want, I was expecting results like this:
1 Aaron ...... 1 db_reader
1 Aaron ...... 2 db_writer
2 Ben ....... 1 db_reader
The first row_number used doesn't seem to use the partition.The second seems to work fine.I know I can break this up into 2 queries but I want to understand where this is going wrong.
Code used:
SELECT
ROW_NUMBER() OVER(PARTITION BY sp.Name ORDER BY sp.name asc) as UserRowNo
, convert(char(45),sp.name) as srvLogin
, 'WIN' + convert(char(45),sp.name) AS WinLogin
[code].....
Hi,
In one CPU installation of SSRS 2005, are there any restriction on number of users accessing the same concurrently?
Please let me know.
Regards,
TNR
I have table A(year int, month int, user varchar(20)), and I am trying to write a view that would show number of distinct users in the last 3 months, last 6 months, last 9 months and last 12 months(all from the most recent year/month)Â in following format:
3 months   6 months   9 months   12  months
number of distinct users     x          y          z            w
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
Hi all,
I want to raise one question which might not relevant to current discussion.
Prob:-- I have some SSRS reports. I want to know for a given time period
1. How many people hit the report.
2. Who are the users hit the report in that time interval.
Is there any query to get that data?
Or,
should I go somewhere to see the data?
NB:- There is not any table in the application which is storing the data
I open up the SQL Server Agent Job window, and I can't see details under the General, Steps, Schedules, or other tabs unless I am running SSMS directly on that server. So much for remote management, eh?
Anybody else experiencing this problem?
Anybody else notice that jobs may fail to complete correctly without raising any errors or logging any issues?
Anybody else remember when, a year ago, SQL Server was a good product?
Anybody think Microsoft is listening?
Anybody? Buehler? Buehler?
e4 d5 xd5 Nf6
I have a login name being displayed when a user logs in, like so: "Welcome: johndoe23"This is displayed through the use of the <asp:LoginName> tag.I want to do a query on the database that only selects data relevant to that userName and wish to assign that logged in username to a variable so we can use an SQL command similar to: "SELECT something WHERE userID=" + loggedInUserName;
View 2 Replies View RelatedI have created a SharePoint external list using SQL Server, the data source is SQL Server. Is there way that I could get the logged-in SharePoint user and stored in SQL Seever?
View 2 Replies View RelatedHello Everyone,
I am backing up my all the databases (around 50 servers and 500 database) using scheduled jobs. I backup my transaction log files at every two hours of interval and databases on daily basis.
I have set option of "Write to Windows Application Event Log" - When job fails during the creation of job in the "Notification Tab" of Create New Job.
As per documentation SQL server automatically records some of the events to windows application event log. After succesful completion of Log backup and DB backup, event gets logged in Windows Application Event Log. And when job fails, I get two events logged in the Windows Application Event Log file, one due to my setting and other automatically by SQL Server.
Due to this Windows event log file is growing much faster and I have to clear it in every 3-4 days.
My quesiton - Is there a way such that to get only failures event logged in Windows Application event log file and any successful backup jobs should not go to Windows application event file?
Can any suggest some idea what should I do?
I am using SQL Server 2000 with SP3 on Windows 2000 Advanced server. Some of my databases are still using Version 7.0/6.5 on NT.
Thanks.
Hi:
I installed sql server express management studio. i'm able to login with the local user and sa user as well. However when I€™m connected and i open a new file to a query window (a sql file for example) the login window prompts me and I need to login again.
Do you think there's a way to overcome this problem and login only once?
Thanks,
Tomer
is bulk logged recovery model support point in time recovery
View 9 Replies View RelatedWe have an existing SSRS server, and have just created a new child domain. We'll be migrating users from the parent to the child, and want to add the users of that new domain with access to SSRS. In the parent domain they are able to access, but after migration with the child domain account, they cannot.
I have added the group CHILDDomain Users with a system user role on SSRS, and PARENTDomain Users was already there.
Is there any additional step I should/could take to get this active?
I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!
View 6 Replies View Related