|
Home > Archive > SQL server exams > January 2003 > Log file reading
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| naresh_sky 2003-01-06, 2:30 am |
| hi to all..
the problem i am facing is not an actual
problem but i just felt like it is one.
i want to open the database file on the
harddisk i know u cant read or access
the database file when the sql server is
running . suppose i stopped the server
then can i read the file .
in which tool can i open the file if i can.
and the other doudt is that.
what is the difference between user defined funtion and user defined inline function.
thanks in advance
naresh | |
| naresh_sky 2003-01-13, 1:01 am |
| HEY GUYS..
THERE R SO MANY TECHIES IN THIS FORUMS.
COME ON PLS TRY ANSWERING THIS QUESTION.
PLS
NARESH | |
| 2lazybutsmart 2003-01-13, 1:57 am |
| You want to open the database file? Why? 
All functions created by users are called user-defined functions. Inline, scalar, mutli-valued. Doesn't matter.
Inline-User-Defined functions can be used to achive the functionality of prametarized views. For example, Consider the following view.
CREATE VIEW CustomersInCanada AS
SELECT CustomerName,Address,Phone FROM Customers WHERE Country = 'Canada'
You can create a more generalized version, CustomerInCountry, by replacing the WHERE Country = 'Canada' with a WHERE Region = @CountryParameter and letting users specify the country they are interested in viewing. Views, however, do not support parameters in the search conditions specified in the WHERE clause but Inline user-defined functions do so.
That's just a broad example, ur on ur own.
cheers,
2lazybutsmart | |
| naresh_sky 2003-01-13, 2:29 am |
| hey thanks buddy 2lbs.
that was great but u left the other one
i want to opent the data file because.
i want to know how the format of data
saved means binary or character.
and how does the page numeber and
fill factor maintained so on...
can i do that
thanks
naresh | |
| 2lazybutsmart 2003-01-14, 7:45 am |
| are u trying to read the transaction log or the database (.mdf) file? | |
| naresh_sky 2003-01-16, 1:01 am |
| yes my dear 2lbs u r plum correct.
u got my point .
i want to read the log file and
the data file can i do it.
thanks
naresh | |
| sjgross 2003-01-17, 3:19 pm |
| Hi Naresh,
I found the following command DBCC LOG at http://www.sql-server-performance.com/ ac_sql_server_2000_undocumente
d_dbcc.asp
=============================
DBCC LOG
This command is used to view the transaction log for the specified database.
Syntax:
DBCC log ({dbid|dbname}, [, type={-1|0|1|2|3|4}])
where:
dbid or dbname - Enter either the dbid or the name of the database
type - is the type of output, and includes these options:
0 - minimum information (operation, context, transaction id)
1 - more information (plus flags, tags, row length, description)
2 - very detailed information (plus object name, index name, page id, slot id)
3 - full information about each operation
4 - full information about each operation plus hexadecimal dump of the current transaction log's row.
-1 - full information about each operation plus hexadecimal dump of the current transaction log's row, plus Checkpoint Begin, DB Version, Max XDESID
by default, type = 0
To view the transaction log for the master database, run the following command:
DBCC log (master) | |
| naresh_sky 2003-01-18, 7:36 am |
| hey thanks susan.
oh that was great i ran the query and it worked fine.
thanks
naresh |
|
|
|
|