Hi!!!

For backup/restore MSDN has good doc.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_aa_9iw5.asp

and for instances

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=29&rl=1

Hi!!!

That extra space reqiured may be data header...

u can get more information on

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp

Hello friends!!cheers!!

Now my EM is working properly...what had happened....when i took oracle's backup then at that time it was crashed and dump files were store in windows folder by default...

Hi!!!

Thanks for all of your valuable time...i got that one

Hi Raj!!!

I got ur point thats nice

USE MASTER

select sysobjects.id from syslockinfo inner join...

Hi!!! Raj..

I checked sql profiler and got reason why that was taking too long time..my table was blocked by one of the job at that time....that was taking too long...

Hi!!!

I got solution through my colleague...actually what i did big mistake was that when i created login there i assigned System Administrator Server Role to my login....when i unchecked that...

Hi!!!

The user i am using is the databse user X....that database i restored from my client side (there also user is X).....Our is windows authetication but i always logging in...

Hi!!!

Check this tread

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

Hi!!!!

SELECT ID,BRANCHCD,SUM(ISNULL(Hrs1,0) + ISNULL(Hrs2,0) + ISNULL(Hrs3,0) + ISNULL(Hrs4,0)......) 'WORKING Hours'

FROM EMPLOYEE

GROUP BY ID,BRANCHCD

Hi!!!!

declare @t as varchar(10)

set @t = 'hi'

select len(@t)

U will get row size is 2!!!

Hi!!!!

Pls check it more on BOL..

USE pubs

GO

DECLARE @ptrval varbinary(16)

SELECT @ptrval = TEXTPTR(pr_info)

   FROM pub_info pr INNER JOIN publishers p

      ON pr.pub_id = p.pub_id

      AND p.pub_name = 'New Moon...

Hi!!!

No way to increase size for varchar more than 8000 and also check for

 Network Packet Size... is the size of the tabular data scheme (TDS) packets used to communicate between...

Hi!!!

RGR'us.....

will that works..

select AOofficeName as Office, count(ARid) as totReferrals ,case when UserName IN ('james1', 'james2') THEN 'James' ELSE UserName END AS UserName

from AdminResource, ProfRequest, Users, AdminOffice

where ARenteredDate BETWEEN '01/01/2005' and...

Hi!!!!!

Check this

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