waiting for the revert please reply....

thkz manu but i havnt got the answer for my 1st 3 questions... and about the java in the 2nd questions......

suppose if i hav a server A and database A which is encryted and now i wanna restore it Server B do i have to restore the service key and...

hi experts plz reply

m getting this error please help ......

declare @body1 varchar(100)

set @body1 = 'Server :'+@@servername+ ' My First Database Email '

EXEC msdb.dbo.sp_send_dbmail @recipients='sam@mail.com',

@subject = 'teee',

...

Thankz lynn but i want to know bcoz i hav read some were that we can do that without specifying the schema ... can u help me in this

tahir1985 please let me know which hav u used for this ......

hello waiting for the reply.............................

please reply asap... gail require ur help...........

Gail wen i check the memory it still shows alloacated 10 GB even if there are no process is going on... if i restart the services it realse the memory

Gail wat about pagefile ... even the process gets completes pagfile shows 11 GB

thkz for the comments gail... gail i have changed many queries and cursors ... but still there is a performance degredation and 1 more i will like to know when...

waiting for the reply............

Like some comment from gail..... and others

there are many cursors and queries and triggers which are running some of them cannot be changed

Memory\Available Bytes

1st - 11080822784

when all the process...

john

there are 1000 procedure and there are 50+ users and there is a blocking .....

wat shud do now ....