Join us March 28, 2024, as we discuss some of the most promising emerging cybersecurity technologies and how you can adopt them into your organizations.
I want to remove a database's records dating from last year and archive them. I could copy the records to a new table, then delete them from the old table, but the effort would be time-consuming. Does SQL Server have a way to accomplish this task...
After more than a year's delay, Intel recently released its Itanium chip to OEMs such as Dell, Hewlett-Packard (HP), and IBM, making 64-bit Wintel systems a reality. To coincide with the initial Itanium release, Microsoft in the third quarter is...
The recovery model, a new option in SQL Server 2000, determines what level you'll be able to recover your database and recently entered data to in the event of a system failure. To set a recovery model, right-click the database in Enterprise...
I selected an identity field as a primary key in a SQL Server table. When I delete the last record, then enter a new record, SQL Server creates a new number. However, when I insert a new record, I want SQL Server to check the maximum number in the...
As I understand it, SQL Server 2000's Open Data Service (ODS) is compatible with Tabular Data Stream (TDS) 8.0, TDS 7.0, and TDS 4.2 running on client machines; SQL Server 7.0's ODS is compatible with TDS 7.0 and TDS 4.2; and earlier SQL Server...
When I use a script to drop a database and reload the database with updated data, I often get an error message saying that the database is in use. I'm the only user. If I stop and restart the MSSQLServer service, the script works fine. I don't...