7800 2
"SqlException: MSDTC on server is unavailable" error in C# Code

One of my projects was working properly, and then I shifted it into another pc, now same code, throws the below error for some SQL queries.

SqlException: MSDTC on server is unavailable.

...

Type
Question
7670 0
Difference between Stored procedure and function in SQL Server
This article, lists important difference difference between Stored procedure and function in SQL Server after giving brief details about Stored procedures and functions (user-defined functions) in SQL server.
Type
Article
7537 0
Top SQL tips for beginners (a must read)
Article give details about SQL, tips, and tricks for beginners
Type
Article
7502 0
Uniqueidentifier in SQL Server
In this article, I have provided details about what is uniqueidentifier in sql server, how to create one and use it in SQL Server.
Type
Article
6483 3
How should i display first 10 records at a time in sql (paging in SQL)?

How should i display 1st 10 records, then next 10 records then next 10 records in sql (paging in SQL)? 

And how should i display the same thing in view using see more link?

...
Type
Question

6473 3
Could not find stored procedure

I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"

 

...
Type
Question
6334 0
Validate Email address in SQL Server
In this article, I have provided example query, by executing which you can validate email address in SQL Server.
Type
Article
5840 0
Best Free SQL Server database hosting
In this article, I have provided list of best free or cheap sql hosting providers available with there features.
Type
Article
5731 2
How to solve error "save changes is not permitted" in sql server?

I am using SQL server 2012 and when trying to edit design of already saved table, i am getting this error

Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created.

Here is the image of the error

...

Type
Question
5724 0
Drop all tables of SQL Server Database
In this article, I have provided various possible ways to delete all tables of SQL Server database, without deleting the main database.
Type
Article

Page 4 of 11