SQL

422 1
Cannot execute script: Insufficient memory Error in SQL server

When I am trying to run a script of 300mb on SQL Server 2012 I am getting this issue

Cannot execute script: Insufficient memory to continue the execution of the program (mscorlib)

here is the image

...

Type
Question
SQL sql-server insufficient-memory cannot-execute-script
370 0
Top SQL tips for beginners (a must read)
Article give details about SQL, tips, and tricks for beginners
Type
Article
sql performance tips
339 0
How to back up SQL Server database?
Article explains various ways to backup SQL Server using C#, Powershell, by generating scripts or writing a script
Type
Article
C# SQL Back-up Database
276 2
How to use switch case statement in stored procedure?

As easily we use the if else statement in stored procedure to check the statement type and there after we perform the desired task. Same thing I want to do using switch case 

...
Type
Question
Switch case in sql procedure Switch case SQL
271 1
how to take back up of all sql server databases?

I am using SQL server 2012 right, and I would like to know how can I take back up of all MS SQL server databases using a single script? or you can explain me a simple method.

 

...
Type
Question
SQL Back-up all-databases SQL-Server

264 2
How to retrieve an int from Stored Procedure and not an objectResult using EF ???

Hi,

 

im trying to set data from my project (mvc.net,c#) by web service and im using a store Procedure to set the data.

after setting i should recive an int id of the record that was created.

my problem is that the SP returns an objectResult when i run it from my project but when i execute it in SQL it returns int...

How to retrieve an int from Stored Procedure using EF ???

...
Type
Question
sql web service
218 2
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
asp.net exception sql exception stored-procedure
214 1
select values from one table and avg of column from another?

I have Two Tables, from one table I want to select all column but from the second table I want to fetch only one column with average value using avg function with related id 

How can I achieve this using SQL query?

...
Type
Question
sql sql-server avg-function

Page 1 of 1