But if the Authenticaion mode is set for SQL Server authentication (sql server registration properties), how windows admin can access the server ?

During your meintenance task, set you recovry model to SIMPLE

hai Dinesh,

You can use ,

backup Log <database name> with truncate_only

or

Backup Log <database name> with no_log

this will not reduce the size of the physical log file

Hai,

I solved the problem.....

I was doing this with Windows 2000 Terminal Service, in that case u cannot open Outlook 2002  while doing xp_Readmail, similarly u cannot run xp_readmail while outlook...

ok thanks....

Actually what i was trying to do is ( As discussed in my previous Query) transposing a table which is having 24 Columns and 2500 Rows,

In that case , if i...

Dear Frank Kalis,

My first question what i mean is,

See i have a table which contains details of Employee Survey,

In the table each row represents an employeess response in the...

Hi Dinesh

see, what  my requirement is, at anytime i should be able to see who all are logged in my sql server through my web browser. in fact this sql...

It could be a problem with the PORT, possibly 1433 might not be open in the network, i will look into that case

Thanks and Regards

Skv

It could be a PORT with problem, possibly 1433 might not be open in the network, i will look into that case

Thanks and Regards

Skv

Andy Warren,

No , i am not able to connect through Query Analyzer also,

it is giving error:

Unable to connect to server x.x.x.x

server:Msg 17, level 16, State 1

[Mircrosoft][ODBC SQL server driver][DBNETLIB] SQL...

Steve,

i don't have any timestamp...

But if i use triggers, the thing is that these two table are in two different serverers physically located in different palce over an intranet

I am...

Thanks, it is working fine

But how can i get the emai id of the sender,

@originator  is giving only the friendly name of the sender

anybody can specify the code