It'll be SQL Server using that, it's non-buffer memory. Reduce max server memory until you're happy with the available MB.

HanShi (1/6/2014)

---

p.avinash689 (1/6/2014)

---

Hi All,

I have a stored procedure like below.

USE [Mama]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[IP_BILLNO](@BILLNO NUMERIC(10) OUTPUT)

AS

DECLARE @Y NUMERIC(4,0),

@d VARCHAR(12),

...

Ed Wagner (1/6/2014)

---

I think I'd have to vote for the 270-column table where the upload is not working properly. It made me...

I don't know why you over-complicated matters so much, there were multiple nested queries for no reason, but this should work

ALTER PROCEDURE [dbo].[icanSP_Convert_GetEntityDependencies] @DocId INT,

@Count INT

AS

...

and it must stay there...

Ok, who has the crystal ball this week?

http://www.sqlservercentral.com/Forums/Topic1527890-146-1.aspx

http://www.sqlservercentral.com/Forums/Topic1528036-391-1.aspx

Your procedure is fetching the greatest billNo from the table and just adding 1 to it. There's no logic anywhere in that procedure to set the bill number for a...

It tells SQL you don't care about the database that you're overwriting so not to give you the errors that you are losing data due to overwriting the DB.

From Books Online

So no additional permissions required.

To debug, you're going to have to dig into what exactly is happening...

Why do you think partitioning will help?

Have you confirmed the problem is locking? If so, what kind of locks from what operation?

Have you pinpointed exactly where in the process the...

Still not enough information. Could be any number of things. Get the book I referenced, do some basic troubleshooting, identify what's happening.

Open Books Online, browse (or search) to the page "Moving System Databases"

Do some reading on SSIS, it's not hard but I'm not going to walk you through it step by step. Start with the SQL help files Books Online.

If it's going to be weekly I'd create an SSIS package and schedule that package with SQL Agent.

Import/export wizard will do that. In Management Studio right click the source databases -> tasks-> export data