How to – Solve SQL Server 2012 Identity Problem. Identity increased by 1000 or 10000

Are you experiencing an identity problem with your SQL Server 2012? Do the identity seeds of your records get increased by 1000 or 10000(in my case it was 10000)? Do you wonder why this is happening and how you can

Read More How to – Solve SQL Server 2012 Identity Problem. Identity increased by 1000 or 10000

Tools – ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe)

The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to add or remove options from an existing database. The Aspnet_regsql.exe file is located in

Read More Tools – ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe)

ASPNETDB.mdf cannot be overwritten. It is being used by database ‘…’

You might encounter this error when you are trying to restore a database. For other problems you may face during the procedure see my post. Assuming you have other issues fixed, let's keep going with this one. Open SSMS. Right-click

Read More ASPNETDB.mdf cannot be overwritten. It is being used by database ‘…’

The backup set holds a backup of a database other than the existing ‘…’ database.

So your are trying to restore a database from the backup of another database with another name and you encounter this error. Here is how you can overcome it. Open SSMS. Right-click on the database you want to restore. Follow

Read More The backup set holds a backup of a database other than the existing ‘…’ database.

Database ‘…’ is already open and can only have one user at a time

If your database is stuck in single-user mode, connect to 'master' database and right-click on your stuck database. Click Properties->Options, scroll to the bottom and change “Restrict Access” value to “MULTI_USER”. How to connect to master db? Easy. First, close

Read More Database ‘…’ is already open and can only have one user at a time

How to – Get Return Value From Stored Procedure

Up to now I was all about problem solving. I decided to, from now on, post “how to” posts too. First one is about returning a scalar value from a stored procedure and getting that value in the code. There

Read More How to – Get Return Value From Stored Procedure

Cannot open database “…” requested by the login. The login failed. Login failed for the user ‘NT AUTHORITYNetwork Service’.

To solve this you must give necessary permissions to 'NT AUTHORITY Network Service'. 1. Open SSMS (SQL Server Management Studio, if you don't have it already, install it.) 2. Expand the “Databases” node 3. Expand [your DB name] node 4.

Read More Cannot open database “…” requested by the login. The login failed. Login failed for the user ‘NT AUTHORITYNetwork Service’.

Cannot alter or drop column ‘Column Name’ because it is enabled for Full-Text Search

If you r seeing this message while trying to modify a column in one of your SQL tables it means you r trying to edit a column which is being indexed for Full-Text Search. What you need to do is

Read More Cannot alter or drop column ‘Column Name’ because it is enabled for Full-Text Search

Adding Fulltext Search Capability to an Existing SQL Server 2008 Express Installation

Ever tried to do a “CONTAINS” query and ended up with an error message saying: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Some Name Here' because it is not full-text indexed. This means that SQL

Read More Adding Fulltext Search Capability to an Existing SQL Server 2008 Express Installation