Search results for query: *

A rollback is a way of undoing or erasing data modifications in a transaction. Sometimes you need to perform several actions (insert, update, delete) in sequence and all must complete successfully for business or data integrity reasons. Example: ATM transfer of funds ($100) from account A to...

To clarify the first line of my last posting - a primary key is not a column, but a constraint on a column or columns...

A primary key is really the same in Access and SQL Server. It is a column that must contain unique values and does not allow NULLS. An identity column is one where the value (a number) is automatically generated by SQL Server, much the same as an AutoNumber column in Access. An Identity column...

Nobody went crazy creating databases or logins (or they just won't admit it). I ran queries against tables sysxlogins (to check srvid) and sysdatabases. Table syxlogins had 67 rows, with srvid being NULL in all cases but one, which was 0. When I ran 'Select * from sysdatabases', I got a few...

Several of us tried to re-register, but it had no effect.

Thanks for the quick responses. We haven't reinstalled Enterprise Manager because the problem shows up for all developers who have that server registered in Enterprise Manager on their machines. Since everyone has the same version as the server (SP3), I assumed that the issue wasn't with the...

Running SQL Server 2000 SP3. This server has about 25 small databases, some of which are offline. Problem occurs in Enterprise Manager - when expanding the Databases folder, (No Items) is displayed. The databases exist and can be accessed via Query Analyzer. Also, the Management folder appears...