@@CPU_BUSY stops incrementing and generates "Arithmetic overflow occurred"

I am using several globals including @.@.CPU_BUSY to log the performance of some stored procedures. It works fine on my dev server, but in production the value reported by @.@.CPU_BUSY on my production server has stopped at 134217727. And when I try to assign its value to a variable, it always generates an error.

For example:

DECLARE @.FOO BigInt
Set @.foo = @.@.CPU_BUSY
print @.Foo

generates

Arithmetic overflow occurred.
134217727

Note that

DECLARE @.FOO BigInt
Set @.foo = 134217727
print @.Foo

works fine.

I understand that when the value of @.@.CPU_BUSY reaches a certain point, its value becomes inaccurate according to MSDN TSQL Reference. I've also seen some descriptions that say the value is supposed to "wrap" back to zero.

So the questions are:
Is the value of @.@.CPU_BUSY supposed to wrap back to zero when it overflows?
Is there a better/more reliable way to do this?

Cheers,
Jeff
by the way:
Select @.@.version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)sql

Moving table with data to another database in sql Express 2005?

How to move some tables with data & procedures etc from 1 database to another in sql server 2005 express edition.

i did by scripting but i transfer tables and procedures and not data

data is the problem.

tnx

I'm already discussing this with you here

http://forums.asp.net/thread/1299924.aspx

sql

Does anyone know what the store procedures that start with
dt_% are? for example dt_properties?
Thanxs
cs
< for example dt_properties?
You can transfer diagrams of the database by using dt_properties.
"cs" <anonymous@.discussions.microsoft.com> wrote in message
news:18fb501c42145$f667e300$a601280a@.phx.gbl...
> Does anyone know what the store procedures that start with
> dt_% are? for example dt_properties?
> Thanxs
|||These are created by Enterprise Manager when you do certain operations. It is OK to delete them, but when you
do such an operation, they will be created again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"cs" <anonymous@.discussions.microsoft.com> wrote in message news:18fb501c42145$f667e300$a601280a@.phx.gbl...
> Does anyone know what the store procedures that start with
> dt_% are? for example dt_properties?
> Thanxs
sql

Does anyone know what the store procedures that start with
dt_% are? for example dt_properties?
Thanxscs
< for example dt_properties?
You can transfer diagrams of the database by using dt_properties.
"cs" <anonymous@.discussions.microsoft.com> wrote in message
news:18fb501c42145$f667e300$a601280a@.phx
.gbl...
> Does anyone know what the store procedures that start with
> dt_% are? for example dt_properties?
> Thanxs|||These are created by Enterprise Manager when you do certain operations. It i
s OK to delete them, but when you
do such an operation, they will be created again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"cs" <anonymous@.discussions.microsoft.com> wrote in message news:18fb501c42145$f667e300$a60
1280a@.phx.gbl...
> Does anyone know what the store procedures that start with
> dt_% are? for example dt_properties?
> Thanxs

Does anyone know what the extended store procedures:
sp_cursorprepexec, sp_cursorprepare
what do they do?
what are they used for?The sp_cursorxxx procedures are internal system stored
procedures used for API server cursors. They are invoked and
used by the data access APIs (ADO, ODBC, OLE DB etc).
There is more information on the specific functions of some
of these in books online under API Server Cursors.
-Sue
On Wed, 14 Apr 2004 04:41:34 -0700, "cs"
<anonymous@.discussions.microsoft.com> wrote:
>Does anyone know what the extended store procedures:
>sp_cursorprepexec, sp_cursorprepare
>what do they do?
>what are they used for?

Does anyone know what the store procedures that start with
dt_% are? for example dt_properties?
Thanxscs
< for example dt_properties?
You can transfer diagrams of the database by using dt_properties.
"cs" <anonymous@.discussions.microsoft.com> wrote in message
news:18fb501c42145$f667e300$a601280a@.phx.gbl...
> Does anyone know what the store procedures that start with
> dt_% are? for example dt_properties?
> Thanxs|||These are created by Enterprise Manager when you do certain operations. It is OK to delete them, but when you
do such an operation, they will be created again.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"cs" <anonymous@.discussions.microsoft.com> wrote in message news:18fb501c42145$f667e300$a601280a@.phx.gbl...
> Does anyone know what the store procedures that start with
> dt_% are? for example dt_properties?
> Thanxssql

.Net Stored Procedures on IA64 SSAS

Does anybody know if it is possible to call .Net stored procedures from a 64 bit Analysis Services Installation? Unfortunately the .Net stored procedures which we are trying to use target the x86 platform and not IA64.

(The procedures use an ODBC driver that is only available to 32 bit applications.)

Any information would be appreciated. The trial and error process gives me an MDX error that says that my stored procedures cannot be found. However, SSAS lets me add the x86 assembly to my database without any problem.

You can't cross 32/64 bit process boundaries within a single process this way. You can't try to load 32bit stored procedure into 64 bit process. Analysis Server is not checking the target platform you compiled you SP for on load, but later as you can see it fails to load it.

If you absolutely must to use the 32bit ODBC driver, you have an option of installing 32bit AS on 64bit platform. But that is highly unintuitive. Take a look if you can find native 64bit version of OLEDB provider instead of using 32bit ODBC driver.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I also would like to add here, that unless you are using COM based sprocs (which are off by default), the .NET sprocs are platform agnostic, just like .NET itself. You can take sproc .NET assembly and deploy it to either 32 or 64 bit server without recompilation - it should work fine.

.Net interface to vss for sql 2000 stored procedures

We would like to use the version control for sql stored procedures through
.net, however, according to Microsoft's implementation procedures it gives
developers "sa" authority. Does anyone know how we can set this up without
the developers having "sa" authority on our database?You can use Windows Authentication for developers staff
"sgerwie" wrote:

> We would like to use the version control for sql stored procedures through
> .net, however, according to Microsoft's implementation procedures it gives
> developers "sa" authority. Does anyone know how we can set this up without
> the developers having "sa" authority on our database?|||We do use Windows Authentication for the developers, however, in order to se
t
this up, SQL services has to run with "sa" authority and Admin rights on the
server, therefore, it automatically gives everyone "sa" rights to SQL. It
doesn't matter
"MAURICIO" wrote:
[vbcol=seagreen]
> You can use Windows Authentication for developers staff
> "sgerwie" wrote:
>

.neRe: Store procedures & Functions

hi,

what is the different between store procedure and function?

when it is right to use sp and when functions?

thanks in advanced

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=233961&SiteID=1

This is link for post about difference between UDF and SP. You can use scalar-valued function anywhere when T-SQL command is expecting a value.

Thanks.

|||ok thanks for the help :)