Does SP have a max size?

Hi all. I'm getting a weird error in a stored procedure:
Servidor: mensaje 208, nivel 16, estado 6, procedimiento RegistrarTabla,
lnea 65535
El nombre de objeto 'RegistrarTabla' no es vlido.
That's spanish but should be:
Server: message 208, level 16, state 6, procedure 'RegisterTable', line
65535
The object name 'RegisterTable' is not valid.
The procedure does not have so many lines, and the number 65535 makes me
distrust.
Does SP have a maximum size or something?
Regards,
Diego F.Diego
I think you should be concered about am error and not about a line of code.
Copy the stored procedure's code to Query Analyzer and run it. It may space
or empty strings within a stored procedure.
"Diego F." <diegofrNO@.terra.es> wrote in message
news:e1YpxfolFHA.572@.TK2MSFTNGP15.phx.gbl...
> Hi all. I'm getting a weird error in a stored procedure:
> Servidor: mensaje 208, nivel 16, estado 6, procedimiento RegistrarTabla,
> lnea 65535
> El nombre de objeto 'RegistrarTabla' no es vlido.
> That's spanish but should be:
> Server: message 208, level 16, state 6, procedure 'RegisterTable', line
> 65535
> The object name 'RegisterTable' is not valid.
> The procedure does not have so many lines, and the number 65535 makes me
> distrust.
> Does SP have a maximum size or something?
> --
> Regards,
> Diego F.
>
>|||That's QA which gives me that error. Doesn't apply to any line. It's a
strange error.
Regards,
Diego F.
"Uri Dimant" <urid@.iscar.co.il> escribi en el mensaje
news:u3CM8molFHA.1464@.TK2MSFTNGP14.phx.gbl...
> Diego
> I think you should be concered about am error and not about a line of
> code.
> Copy the stored procedure's code to Query Analyzer and run it. It may
> space or empty strings within a stored procedure.
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:e1YpxfolFHA.572@.TK2MSFTNGP15.phx.gbl...
>|||Diego
If you post DDL + samle data we will be able to test and maybe reproduce the
error's behaviour.
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OqS00qolFHA.1968@.TK2MSFTNGP14.phx.gbl...
> That's QA which gives me that error. Doesn't apply to any line. It's a
> strange error.
> --
> Regards,
> Diego F.
>
> "Uri Dimant" <urid@.iscar.co.il> escribi en el mensaje
> news:u3CM8molFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||Check that u are connected rt database in which 'RegisterTable' is
present|||While we wait for you to send some DDL, let me ask you this: is
'RegistrarTabla' the name of a user table or your procedure?
ML|||65,535 lines? Have you ever considered publishing that stored procedure as a
book?
"Diego F." <diegofrNO@.terra.es> wrote in message
news:e1YpxfolFHA.572@.TK2MSFTNGP15.phx.gbl...
> Hi all. I'm getting a weird error in a stored procedure:
> Servidor: mensaje 208, nivel 16, estado 6, procedimiento RegistrarTabla,
> lnea 65535
> El nombre de objeto 'RegistrarTabla' no es vlido.
> That's spanish but should be:
> Server: message 208, level 16, state 6, procedure 'RegisterTable', line
> 65535
> The object name 'RegisterTable' is not valid.
> The procedure does not have so many lines, and the number 65535 makes me
> distrust.
> Does SP have a maximum size or something?
> --
> Regards,
> Diego F.
>
>|||OK, thank you all. It was a stupid problem. I was altering a SP with a name
changed, so the name of that SP didn't exist at all!.
I'm a bit embarrased :-P
Regards,
Diego F.
"Diego F." <diegofrNO@.terra.es> escribi en el mensaje
news:e1YpxfolFHA.572@.TK2MSFTNGP15.phx.gbl...
> Hi all. I'm getting a weird error in a stored procedure:
> Servidor: mensaje 208, nivel 16, estado 6, procedimiento RegistrarTabla,
> lnea 65535
> El nombre de objeto 'RegistrarTabla' no es vlido.
> That's spanish but should be:
> Server: message 208, level 16, state 6, procedure 'RegisterTable', line
> 65535
> The object name 'RegisterTable' is not valid.
> The procedure does not have so many lines, and the number 65535 makes me
> distrust.
> Does SP have a maximum size or something?
> --
> Regards,
> Diego F.
>
>

Does ASP 3.0 Support Varchar(Max) Data Type

Does ASP 3.0 support Varchar(Max) Data Type?

I am having problems displaying asp 3 recordset with varchar(max) data type...

ADO.NET 2.0 supports varchar(max) field. Older versions will support it as well since SQL will send back as text to older clients.

Does anyone know a utility/batch script to Warn when close to Max DB size

Hello Group
Does anyone know of a utility or Batch script (osql or Windows cmd or mix)
to Warn an Admin when a MSDE DB is closing in on 2 GB in size (or 2005
Express closes in on 4 GB).
Any leads or tips will be appriciated highly
Best regards
Uffe
hi Uffe,
Uffe Bak wrote:
> Hello Group
> Does anyone know of a utility or Batch script (osql or Windows cmd or
> mix) to Warn an Admin when a MSDE DB is closing in on 2 GB in size
> (or 2005 Express closes in on 4 GB).
> Any leads or tips will be appriciated highly
> Best regards
> Uffe
in MSDE you can perhaps schedule a job defined to include a way to gather
that kind of data, using direct access to the sysfiles database table or via
DBCC SHOWFILESTATS..
you can then validate that data against a userdefined treshold and notify
someone via NET SEND or mail via SMPT alternative, like exploded in
http://www.karaszi.com/sqlserver/info_no_mapi.asp,
http://www.dbmaint.com/SmtpAlerter.asp , thus defining a kind of alert..
PRINT 'MSDE';
PRINT '--';
USE Northwind;
PRINT 'sp_spaceused';
EXEC sp_spaceused @.updateusage = 'TRUE';
PRINT '--';
PRINT 'DBCC SHOWFILESTATS';
CREATE TABLE #tmp_sfs (
fileid int,
filegroup int,
totalextents int,
usedextents int,
name varchar(1024),
filename varchar(1024)
);
INSERT INTO #tmp_sfs
EXECUTE('DBCC SHOWFILESTATS');
SELECT LEFT(DB_NAME(),10), (SUM(totalextents) * 64) / 1024 AS [totalextents
in MB], (SUM(usedextents) * 64) /1024 AS [usedextents in MB]
FROM #tmp_sfs;
DROP TABLE #tmp_sfs;
PRINT '--';
PRINT 'sysdatabase query';
SELECT LEFT(DB_NAME(),10) AS [Database], sum(convert(float,size)) * (8192.0
/1024.0) /1024.0 AS [Size in MB for Data files]
FROM dbo.sysfiles
WHERE (status & 0x40) <> 0x40;
SQLExpress does not provide the SQL Server Agent, so you can perhaps rely on
the native OS scheduler for something similar.. as regards the SMPT
integration, you have to (possibly) write your own CLR based mailer
solution.. I personally will... then, from the OS scheduler, you'll execute
SqlCmd command line tool to perform the SQLExpress connection and data
retrival...
just an idea..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks to Andrea and Satya for quick answers
I will look into your suggestions and return if I find a solution.
I also looked up some Scripting options, so there are as usual more than one
road to Rome
Best regards
Uffe Bak