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