Here is my steps in detail.

This table contains trigger, that's why I wanted to do it like this in a loop.

sorry,this is sql2000

yes,

EXEC MASTER.DBO.XP_SENDMAIL

@RECIPIENTS='',

@Copy_recipients='',

@SUBJECT="'",

@message ="",

@ATTACHMENTS='\\

Thank you, I couldn't find information if I need additional lisense for creating another instance on enterprise version

I have another question, how would I know that I need to add more Ram?

Thank you

Thank you everyone, but article recomends 6GB set to 4800, how did you come up with that number 4096 and plus 2 gb.

Thank you

Thank you

sorry it is 15000 not 1500

Thank you very much, I will changed it,what is your recomendations is 1500 enough?

PhysicalMemoryGBVasGBBufferPoolCommittedMemoryGB BufferPoolTargetMemoryGB

5.99 8192.00 2.21 ...

I have a lot of sp and I want provide access to all sp with execute,is there way to select all of them at the same time or I have...

I rec reated function under other database without any problems.

Here is what function what is doing:

[dbo].[Case](@string varchar(8000)) returns varchar(8000) as

begin

set @string = lower(@string)

declare @i int

set @i = ascii('a')

while @i <=...

Oh, this is a new server and we installed standard version and realized that we need now enterprise and wanted to know what is the process, is there upgrade for...

when istalling sql server2008

If you look under this screen there is only one option to use the same account for all sql Services,but how can I go and create...