Query 1:

I agree with your comments, But the custid is unique with custname (custid is unique values generated from application and custname may duplicate with other custid). some customers may...

I got you

Thank you very much for sharing

Regards

Rock...

Yes i did . it was inserted. now the size is 10MB. I think sql server will look from the file stream location after inserting the document not from...

I agree. I know it will be stored in file group which contains files stream data. i inserted a 10mb file in the file stream column, i didn't find any...

i accept it. but i have a problem using the file stream in sql server 2008.

I have created a table using file stream

ex: USE TEST_DB

...

actually i have migrated every thing from sqlserver 2005 standard to sqlserver 2005 developer edition.after that i created the linked server between sqlserver 2005 standard and sqlserver 2005 developer edition....

any idea on this issue??

Hi,

file stream was introduced in sql2008. I am bit eager to know, what about earlier versions of sqlserver2000 and 2005?

i thank each and every one for sharing ideas.

Regards,

Rock..

is there any way other than file stream in sqlserver 2008 for storing large files suchas 10gb file.

local login:: sysadmin user

impersonate i used

for a login not defined in the list above connections will,

be made using this security context

remote user (not a sysadmin)

remote pass

i am bit worrying about the reports. remaining things i can handle it.

can any one tell me how to migrate all reports and their corresponding users to a new server.

Thanks...

I want to migrate all databases,sp's,jobs,ssis packages,reports etc of sqlserver 2005 from one machine to other machine.

please guide me on this one

Regards

Rock...

i disabled the encryption to the test database.

after that also same err

any idea???

i use to connect with SSMS