Thanks racosta for you help

Thanks mromm, I saw the same code in the sp_table_privileges.

\\servername\folder is not working its like \\Servername\DriveName\Folder.

It did not help either. Anyway thanks for the suggestion.

Thanks it works.

Thanks a lot Antares686.

I change the directory in the Tracing folder On the ODBC DataSource Adminstrator Folder.

"look @ BOL for an example"

I could not understand what is BOL Could you PLEASE explain me what it is.

Thanks.

I don't think this is transaction log file.

When I go to the Properties of pubs db the log file is pubs_logs.ldf is stored in mssql\data\ directory, but the SQL.LOG file...

sp_detach is not fould

The object 'sp_detach' does not exist in database 'master' and other db too.

I just want to move the SQL.LOG file to different drive and configure Server to...

Thanks for the reply. I will change the timestamp column to datetime and write a trigger to track the modified time.

Thanks again

I just inserted data to tabletest which has column a int and b timestamp.

I wanted to display the timestamp field as a datetime data when I use convert the date...

The Column b is timestamp datatype (nullable)