Data files in Flash Drive

Hi friends,
i want to know something abt sql server installation and database properties as under.
1) how much disk space reqd by multiuser sqlserver 2000 db to install ?
2) is it possible to install sql 2K on Flash Drive ( gen connect at USB) ?
3) When v create a database user Enterprise Manager , which files created by database ?
4) If i Know datafiles name of a database e.g. pubs , and if v copied on cd and paste on other system which has sql 2K install , does those database works ?
5) is it possible to create database on flash drive ?

thanx in advance.Come on...are these trick questions?|||I suppose it could be done, but you would have to be very sure that you properly detach the database before someone goes and unplugs the USB drive. I think you would set yourself up for a heck of a lot more user errors than SQL Server errors this way.

Data access in a variable

Hello Friends

i have one problem, i have to need fatch the data from database .

in the web form i take three grid view and i put the query "Select Top 1 coloum1 from tanlename order by newid()" .

when the data came from database there is no sequence series . so i want to take fatch the data from database in variable like int a , b , c and call the data in those variable

and put up in the feild

example :- welcome to Mr "Data call from data base (1) " how are you "Data call from data base (2)" bbye and "Data call from data base (3)"

Answer "- welcome to Mr "ASHWANI" how are you FINE OR NOT" bbye and "TAKE CARE"

there is all capslock on value came from databse and these value in the web page store in a variable

like int a ;

int b;

int c;

please help me please i have a huge problem

Ashwnai

Hi ashwani2kumar,

Not 100% sure what you mean. How do you fetch those data from your database? what does you select query look like?

welcome to Mr "Data call from data base (1) " how are you "Data call from data base (2)" bbye and "Data call from data base (3)"

Answer "- welcome to Mr "ASHWANI" how are you FINE OR NOT" bbye and "TAKE CARE"

If your string is fixed, i mean, those "welcoem to, how are you ..etc" stuff are fixed, i think you can assemble that string within a stored procedure, like this:

create procedure sp_string par1_defination,par2_defination,// i don't know how do you fetch those data, so, fill in those query parameters by yourself@.ret_str varchar(200) outputasdeclare @.str1 varchar(20),@.str2 varchar(20),@.str3 varchar(30)select @.str1=Namefrom table1 where// your query 1select @.str2=colnamefrom table2 where// your query 2select @.str3=colnamefrom table3 where// your query 3set @.ret_str='welcome to Mr'+@.str1+'how are you'+@.str2+'bbye and'+@.str3return

Hope my suggestion helps

cyrstal report into asp

Hello friends,
I am a newbie in crystal report - working on 9.2 version i have created a report and would like to view the same in an asp page -
Please if anybody can help me out with this - wanted steps to acheive the same
Thanks in advance
sandyGive a look to -->
http://www.thinkydink.com/crystal.html
This tutorial assumes you already know how to code in ASP and your Crystal and IIS servers are already set up and fully functional.