Questions tagged [sysdatabases]
4 questions
1
vote
2 answers
Is Redux an alternate to Sessions, Cookies or is a persistant database?
I want to know if redux has its own database or need MongoDB, MySQL or other databases?
Is it the alternate to sessions, cookies, internalStorage, LocalStorage and IndexedDB?
Is redux the best way to pass the states/data between react…

AndrexCode
- 11
- 1
- 3
1
vote
2 answers
How does one select the server name in a sys objects query
In T-SQL, I am trying to do something like :-
select * from [server_name].dbo.sys.objects
but I keep getting the error 'Invalid object name..'
I ultimately want to compare all the databases of the two servers
(something like the…

heyNow
- 866
- 2
- 19
- 42
1
vote
2 answers
How can I get an accurate count of computers logged in to my SQL Server database?
We license our software by number of workstations.
I have a query that I have used for years to get an accurate count of the workstations logged in to my SQL Server database. For simplicity, all users use the same login name/password. This is built…

KimM
- 17
- 4
1
vote
2 answers
MS SQL Server 2000 - check for existing database error
I use MS SQL Server 2000 SP4 and I have this part of script, that checks for existing database:
IF EXISTS (SELECT * FROM sysdatabases WHERE name='MY_DBNAME')
BEGIN
PRINT 'Using the existing database MY_DBNAME.'
USE MY_DBNAME
END
ELSE
BEGIN
…

Aoi Karasu
- 3,730
- 3
- 37
- 61