Use this tag for questions specific to the 7.0 version of Microsoft's SQL Server.
Questions tagged [sql-server-7]
18 questions
-1
votes
1 answer
mssql 7.0 can't identify empty db entries
pretty new to sql in general, I have to identify 52 "empty" entries in our db to see which contacts they are connected to, if any, and have been unable to isolate them so far. We are using mssql 7.0 on a windows 2000 vm.
What i mean by "empty"…
mello
- 1
- 1
-1
votes
1 answer
Track logins on SQL Server 7.0
We have an old SQL 7 server. I would like to migrate the databases and users to a new server, but only want to transfer active users.
How can I track logins to determine which users are currently active?
-1
votes
1 answer
update sql query excluding those in another table
I have two tables, pricelist.plpart and bsp_priceupdate.xplpart
all prices in pricelist table need to be updated with 3% EXCLUDING those in the bsp_priceupdate table.
i will be running this update in sql 7.
Appreciate your help.
D
gomo
- 1
- 1