Pleae verify if you have the /3GB switch in the boot.ini file. this would atleast help you in using the available memory optimally.

One of the reasons for sp_cursorfetch calls are because of server side cursors. Below is an excellent article explaining the same.

http://www.sqlteam.com/item.asp?ItemID=11842

Regarding a new instance, i think it does give you some flexibility in managing your resources but at the cost of overheads. I would concur with Allen that with the...

I agree to Allen, you might want to set a higher value for memtoleave area.

Can you try running the dts package manually outside the job ?

What are the datatypes for vmus00.se_dispute_summary.data_per_dt  and

vmus00.se_dispute_detail.data_per_dt

Can you try to backup master from query analyzer and see if you get any errors.

backup database master to disk = ''

In what instance are you seeing the error message ?

You can write a small script to read out the data(vbscript or osql) and you can then zip up the file. You can then schedule the script from windows or sql server.

Can...

how are you connecting to the database from the application? if you are using ODBC, you might want to check the Use ANSI nulls, paddings, and warnings check box. Its...

Below is a script you can schedule. It will grant execute permissions to all the procedures in your database to the user you specify. Create the procedure  in master database and select...

hi nos.

Thanks for the correction. Your understanding is correct for each instance get a private virtual 3 GB space. But it gets tricky if you want to use memory more than...

You need to know the domain name for the phone and then you can just send an email to <A href="mailtohoneno@abc.com">Phoneno@abc.com e.g. if...

You can create the procedure below in you master database and run this procedure from the database to which you want to grant permissions. Also, the default role name is...

Below is an excellent article by Ken.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_01262004.asp