MediaBanc
asked on
Add Primary Key (Clustered Index) while database is online MSSQL
Hi Experts!
I would like to ask if is it possible to add primary key to a database that is online and used by production? I haven't tried yet, I'm scared having the database crash.
By the way, I'm using SQL Server 2005 Standard Edition.
Cheers!
I would like to ask if is it possible to add primary key to a database that is online and used by production? I haven't tried yet, I'm scared having the database crash.
By the way, I'm using SQL Server 2005 Standard Edition.
Cheers!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.