just received in mail ,i like it .

You have not mentioned how you are going to copy ,can you tell are you going to use xp_cmdshell for copy or what?you can use xp_fixeddrives to check free space

ReadCommited is default isolation level in sql server

here is more information that you can get on isolation level

http://msdn.microsoft.com/en-us/library/ms173763.aspx

and here is the link that you might find answer to...

May i know what is the reason why you need data from Secondary database to live database again?

you wrote function return time float or numeric type .but when you add "," in numeric to separate value numeric value no longer will be numeric.if you want format...

Navigate to Registry values

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\Language\eng

and

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRoot>\MSSearch\Language\enu

clear value for WBreakerClass.

Sql server consider A/AN/B12/Y(02) as one word.

above both path i have taken by assuming that you are using...

Got the Reason why error comes?and it leads me to schema modification.

Hi,did you got solution of this problem i am having same problem.

if width of nvarchar column is nvarchar(max) then please try to convert it to varchar(max).

did you try to convert it to varchar(max)?

You know there is nice book out there SQL Server 2008 Query Performance Tuning Distilled by Apress.

you can read it ,we have to see why query is behaving bad,then we...

nsaireddymca (6/15/2011)

---

some people told when ever we are using char data type memory will be wasted

...

That's what yet i am looking for.

But Movie,Reading,hanging out with friend is great.

Yes,Just convert Column varchar to nvarchar.

Here is the link http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx,where you can get comparison between all edition.