Update Query on MS Access
Microsoft programmers are always very particular on their way of approaching problems. Since they are…
0 Comments
MS SQL Server: Anomalies 2
We had a database in MS SQL 2000 server. The server/database was configured NOT to…
0 Comments
Firebird SQL: The Power of Simplicity
Firebird SQL Server has always been a "proper" database system since it forked from Borland's…
0 Comments
MS SQL Server: Using Remote Servers (Linked Servers)
Sometimes I need to have a quick way of transferring data from one database to…
0 Comments
MS SQL Server: Anomalies
Backup/restore databases: After the restore, you must revoke (sp_revokelogin) and grant access (sp_grantlogin) to users…
0 Comments