downloading database to local mdf file, sql dumb on SMSE

Hi,

I'm trying to work on a database when I'm not connected. I can't figure out how to get a local copy of a database.mdf that I created on the server, onto my hard drive, using SQL Management Studio Express. Does anyone have any suggestions? I'd be forever in your debt. Thanks

Hi,

You can backup/restore database or your detach/attach database.

Use sp_detach_db procedure and sp_attach_db procedure to achieve this.

For more information, check

http://msdn2.microsoft.com/en-us/library/ms188031.aspx
http://msdn2.microsoft.com/en-us/library/aa259611(SQL.80).aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

doubt in crystal report(help needed Urgently)

hai

I have one doubt in crystal report.I am using crystal report 7 version.I added a databse to report and i connected that report with visual basic and my report is working.Except that i cant refresh my report at runtime and so it displays the same values repeatedly.

I cant use crystal report 8 or 9 or 10.

Help needed urgently

Bye
Ramyafrom file menu of crystal report , uncheck the option of 'Save Data with Report', then save the file and try .|||hai

i have one doubt i am using crystal report from visual basic and not directly from crstal report.

That is i added report at project itself and so where to change that option

Bye
Ramya