10/09/13
Problem
When trying to restore a backup over an existing database, the following error appears:
RESTORE DATABASE is terminating abnormally. The tail of the log for the database "DATABASE_NAME" has not been backed up.
Use BACKUP LOG WITH NORECOVER… more » 01/30/13
10/28/13
Problem
The following error appears when trying export data from SQL Server to a network share with BCP utility:
xp_cmdshell 'BCP "SELECT COLUMN_1, COLUMN_2, .. COLUMN_N FROM TABLE_NAME"
QueryOut \\SERVER_NAME\SHARED_FOLDER\FILE_NAME.TXT -c /… more » 04/10/12
Below it?s a simple schema to easy understand the difference between the primary key and unique key.
For detailed information check the online Microsoft documentation.
Primary Key is a combination of Unique and NOT NULL Constraints so it can?t h… more » 10/18/13
Problem
After connecting to a SQL Server 2012 instance using SQL Server Management Studio 2008 or 2008 R2, and trying to display different objects (views, tables, etc) the following error is displayed:
Index was outside the bounds of the array. (Micro… more » Tags: microsoft.sqlserver.smo
|
06:43:00 am, by 
