I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"
...
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
...
I have already created SQL Server database, but when I am trying to run a query that requires full-text search enabled database, it is not working and throwing error
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblLocation' because it is not full-text indexed.
So, how can I enable full-text index to remove above error?
...When I am trying to login into my local database server using SQL server management studio, I am getting an error, as shown below
A connection was successfully established with the server, but then an error occurred during the login process.
(provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) ...
Hello, I am trying to get Sum of three columns from three different table and get results table using SQL.
Suppose here are my tables
Table 1: raw_item_fcst
Table 2. Raw_item
Table 3 . inventory_data
I try to write query to fetch data from these tables using subquery , Here is my sub query
...