The table can contain varchar columns but the statement must be nvarchar.

That's because you have declared your statement as varchar. sp_executesql only accepts nvarchar.

Your

DECLARE @SqlQuery varchar(max)

should be

DECLARE @SqlQuery Nvarchar(max)

You have two heaps, which are not even close to identical. Delete from a heap does not deallocate pages. I suggest creating a clustered index on these tables and then...

I was avoiding the "why" because I don't have an answer.

This works

DECLARE @Numeric NUMERIC(28, 10) = 8E10;

SELECT @Numeric;

This doesn't

DECLARE @Numeric NUMERIC(28, 10) = '8E10';

SELECT @Numeric;

It also works with the STR function

SELECT CONVERT(NUMERIC(28, 10), STR('8E10', 28, 10));

Try the following code and watch the memory usage for SSMS in task manager. Make sure you have saved all your work 😉

WHILE 1=1

BEGIN

PRINT '(1 row(s) affected)';

END;

The ISNUMERIC function tells you if you have a valid int, numeric or float. 8E10 is a valid float.

declare @varchar varchar(50)

select @varchar = '8E10'

select @varchar

select isnumeric(@varchar)

select convert(float, @varchar)

go

I have had this before and it was due to SSMS running out of memory. My experience of it was when I had SET NOCOUNT OFF while doing a batch...

I am not voting because I use all three options.

pradeep.mohan (9/13/2013)

---

Yes, now i can able to restore via GUI...Many thanks.

but MSDB database size still 50GB how can i reduce the size after cleanup backup history table.

So what is the...

Do you think SCOPE_IDENTITY() could be one of the reasons?

Thanks Gail. And the reason is?

Hi,

If you are only dealing with squares it is quite easy.

Firstly you only need the top left and bottom right co-ordinates:

CREATE TABLE Squares

(CellNo CHAR(2) NOT NULL,

TopLeftX INT NOT NULL,

TopLeftY INT...

If disk space is not an issue then I would probably leave it. Are you able to restore via the gui?

My apologies for posting a Spatial answer in the 2005 forum. I must learn to read properly 🙂

To answer your question for the 2005 platform I must ask a question....