how data store on server?

Hi all,
please, show me How to data is store on the server ?
thanks for reading.There's a lot of information about this on the online-books which come with SQL Server.
Every database has 3 types or groups of files:

Primary/Main data file (.MDF): this is the base point of the db, it can store data, and/or pointers to pages inside the secondary files
Secondary data files (.NDF): these files store data
Registry (log) files (.LDF): these files are used to restore de db.

You can have 1 main data file, and many as you want of the other types. The reason for having more than 1 file of data, could be the limitation of 4GB in Windows. Every file is divided in pages, first page is 0, second page is 1, and so on.

You can search in the online books for more information... You can ask me for something more specific, this was a general vision of a large and complicated topic.|||The reason for having more than 1 file of data, could be the limitation of 4GB in Windows.

4 GB limitation in Windows ... which version of windows are you using ... I am confused :confused:|||Well, Fat32 Max File Size is 4GB, am i wrong? I use windows 2000 and XP, both with fat32.
NTFS has no max file size limit.|||No ... you are not wrong ... but i havent seen servers running on FAT32 for a long long time.|||No, no, the server is a win 2003 server with NTFS... i have the 4gb max file size limit in my computer because the admin (if I could catch him...!!!!) installed XP with FAT32, i dont know why... i never had problems with it (i nerver had a 4gb file in my local system, even i didnt know that limitation), so i didnt worry about that, but 2 months ago my local installation of SQL server growed, and reached the max file size, and the problems begun...
Except for that limitation, i dont find a reason for having more than one file for data storing...

how could I store images in a database?!!

hi everybody,can anybody help me out by telling me how could I store images in a database, and how to insert new images at run time to a database and thanks

If you have C# .NET (Express, and probably other versions too), it comes with a "Movie Collection Starter Kit" example which has a button that loads an image into the database. Just go to File->New Project, and select the "Movie Collection Starter Kit" template. Open ListDetail.cs, and find the ImportImage method.

how could i hide my finacial data to sa when i store them in sql server 2k?

what we store in db is informatin about company finacial status.
we don't want anyone in charge of the server can read the those data.
what can i do without 3rd party software like activecrypt?
thank you.You can't prevent a member of the sysadmin role in SQL Server (like sa) from
viewing data so you would need to encrypt it either before storing it in SQL
or use a third party product
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"xuyan" <microsoft.net@.sina.com> wrote in message
news:eRfUysosFHA.3404@.TK2MSFTNGP09.phx.gbl...
> what we store in db is informatin about company finacial status.
> we don't want anyone in charge of the server can read the those data.
> what can i do without 3rd party software like activecrypt?
> thank you.
>|||Hi
Where does the info reside? One or many tables?
You can adde the user to db_denydatareader role and make sure that he/she is
not a member of sysadmin server role.
"xuyan" <microsoft.net@.sina.com> wrote in message
news:eRfUysosFHA.3404@.TK2MSFTNGP09.phx.gbl...
> what we store in db is informatin about company finacial status.
> we don't want anyone in charge of the server can read the those data.
> what can i do without 3rd party software like activecrypt?
> thank you.
>

how can i view customized error message?

hello
when error messages are added to my sql server, how can i view them?
i can not find them from the table (in master)
where does mssql 2000 store this information?
thank you
Hank,
Are you referring to master..sysmessages table?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"hank" <anonymous@.discussions.microsoft.com> wrote in message
news:7DE6C377-84FF-411D-BCDD-A12848CA58C5@.microsoft.com...
> hello
> when error messages are added to my sql server, how can i view them?
> i can not find them from the table (in master)
> where does mssql 2000 store this information?
> thank you
|||thank you!!

how can i view customized error message?

hello
when error messages are added to my sql server, how can i view them?
i can not find them from the table (in master)
where does mssql 2000 store this information?
thank youHank,
Are you referring to master..sysmessages table?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"hank" <anonymous@.discussions.microsoft.com> wrote in message
news:7DE6C377-84FF-411D-BCDD-A12848CA58C5@.microsoft.com...
> hello
> when error messages are added to my sql server, how can i view them?
> i can not find them from the table (in master)
> where does mssql 2000 store this information?
> thank you|||thank you!!

how can i view customized error message?

hell
when error messages are added to my sql server, how can i view them
i can not find them from the table (in master
where does mssql 2000 store this information
thank youHank,
Are you referring to master..sysmessages table?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"hank" <anonymous@.discussions.microsoft.com> wrote in message
news:7DE6C377-84FF-411D-BCDD-A12848CA58C5@.microsoft.com...
> hello
> when error messages are added to my sql server, how can i view them?
> i can not find them from the table (in master)
> where does mssql 2000 store this information?
> thank you|||thank you!!

how can i use a conditional where clause in sql statment

I have a store procedure where i need to use conditionel where clause

One possibility would be to make the conditional parameter nullable and then add an IsNull check to your where clause that only evaluates the condition when the parameter is set.|||

hi

you can use coalesce function to implement conditional where clause in sql statement.

for more details please refer this link

http://www.sqlteam.com/item.asp?ItemID=2077

regards