This might clear things up:

http://www.sql-server-performance.com/awe_memory.asp

I don't know the book, but you're sure you have a table named Software_Category_T in the current db?

Is the /3GB switch correctly set?

Okay, here's the explanation for your observation straight from BOL

Auto options control certain automatic behaviors.

AUTO_CLOSE

When set to ON, the database is closed and shut down cleanly when the last...

Please avoid multiple postings on the same topic!

It almost impossible to check who has answered what where already.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=148946

http://www.itrain.de/knowhow/sql/tsql/xp/xp_dir.asp has some examples on how to do this. It's in German, but the code speaks for itself. Note that these procedures are ostly undocumented, so here goes the usual...

How much RAM is in the server and what version of SQL Server are you using?

Standard edition cannot adress more than 2 GB of RAM.

Correction to myself

In addition to just simply removing the ^ to remove the characters from a string you also need to change the...

Steve,

from the previous posts by the questioner it reads different

It should be coming in the following order.

RKA10

RKA11

RKA100

RMX10

RMX11

RMX100

RSA12

RSA120

RSA139

RSBH01

But I was actually focusing on the...

May I add, that your functions could greatly simplified to

CREATE FUNCTION dbo.RemoveChars(@Input varchar(1000))

RETURNS VARCHAR(1000)

BEGIN

DECLARE @pos INT

SET @Pos = PATINDEX('%[^0-9]%',@Input)

WHILE @Pos > 0

BEGIN

SET @Input = STUFF(@Input,@pos,1,'')

SET @Pos = PATINDEX('%[^0-9]%',@Input)

END

RETURN @Input

END

GO

SELECT...

Somehow I just came across this one:

http://www.ag-software.com/sqlscribe/

FWIW

What is the setting for "autoclose" on this database?

One might also consider the use of sp_pkeys or OBJECTPROPERTY(...'TableHasPrimaryKey')

I guess because of all the spam, giving or asking for eMail isn't the best idea. Although I never received spam because of being here. However, I think using the...

Its not pretty, but I can find no better way of stripping the time off a datetime value, which could produce erroneous results

Yuk, there are certainly better methods for this....