Category Archives: SQL

By August 11, 2008

Error: Could not drop object ‘dbo.tablename’ because it is referenced by a FOREIGN KEY constraint. (.Net SqlClient Data Provider) Type “sp_help tablename” in a query analyzer. In the last row of the result list, you will find a list of tables which has refered Mytable as primary key; Go to those tables and drop those

Read More
By July 18, 2008

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

Read More
By July 04, 2008

error Login failed for user ‘NT AUTHORITY\NETWORK SERVICE Make sure the user has been created within the SQL Server and has permissions for the db. If you are connecting directly to the file then you must give the network server user full access to the .mdf and log file.

Read More
By May 23, 2008

Error Error 0xc00470fe: Data Flow Task: The product level is insufficient for component “Source – test.txt” (1). (SQL Server Import and Export Wizard) =================== The “The product level is insufficient” error means you are missing the SSIS Service. This can be resolved by reinstalling your local copy of SQL server or by installing Service Pack

Read More
By May 17, 2008

1. Microsoft have a background document on Full Text Search concepts and I suggest that you read that first. 2. The fundamental fact of full-text indexing is that the database requires extra files called the catalog. You still have the normal .mdb and .ldb files, but you also have a folder called FTData which contains

Read More
1 3 4 5 6