Hey Grant,

"\E" is share drive which have all the permission.

and can you please explain me something about as you written in above post

service account that SQL Server runs under. Not...

Hi All,

I have all the permission, because i am login by using "sa"

as my login to SQL Server 2005 and the Share I am using is my own System and...

Hey Grant,

How can you manage all the Schema?

Are you giving permission to all schema for access?

Cheers!

Sandy.

Hey Grant,

I used your query like this :

BACKUP DATABASE TEST TO DISK = '\\111.111.1.111\E\abc.bak'

Its Showing error like this.

Msg 3201, Level 16, State 1, Line 1

Cannot open backup device '\\111.111.1.111\E\abc.bak'. Operating...

Hey Piotr,

Thanks,

I got your point,

I was uploaded the Database by running Script only through Ftp Site.

when its show dbo as error I replaced with one space

like this : replace...

Hey Madhivanan,

I have Resolved this Issue by own,

Thanks for your help.

Cheers!

Sandy.

Thanks Oana,

Cheers!

Sandy.

Thanks Jeff Moden,

Cheers!

Sandy.

Hey Karthikeyan,

Just have a Look on this Post.

Hope, you can get idea from this.

Cheers!

Sandy.

Hi Steve & Grant,

Really feel great to know this Answer,

I really Appreciate both of you.

Now I am Clear on my question.

Thanks again for the Same.

Cheers!

Sandy.

Hi Michael & Grant ,

Thanks for your quick response.

As per Grant, the growth should be Sql Server wise but wats about the log file size?

I hope the same regarding growth.

but...

Hey jmuldoon,

Thanks for Nice Help.

I used following Query to solve this ..

SQL Query

===========

DECLARE @CntDell INT, @Count Int, @Result NVARCHAR(MAX)

SELECT @CntDell = Count(*) from TmpDell

select @CntDell

Select @Count = 1

WHILE @Count <=...

Hey Grant,:)

XQuery is Better than OPENXML,

As far I know and its coming newly in SQL Server 2005,

This much I can say, because last time I used this

XQuery Script rather...

Hey Andras,

OPENXML is available in SQL Server 2000. If you are not yet on 2005, then this is a major advantage

XQuery was introduced in 2005. It can be more...

Hey roge,

Cool Link,

Thanks for Helping me...

Cheers!:)

Sandy.