sorry i am not an expert on command prompt codes.

try this

osql -E -S server_name -d database_name -Q "EXEC schema.spname param1, param2">C:\Filename.txt

Does it gone till your DB (all applications) to stp working?

i want the table structure and...

why dont you schedule it with the help of SSIS and Agent services.

Can you post some more details like

Table size, Table structure and query which is mostly experiencing timeout.

DB size, server configutation, storage information.

Have you tried SSIS?

Index rebuild arranges the index which how it is supposed to be, so data retrival will be faster.

but considering only 40 users there is some serious concern on DB design.

kindly...

Have a look at this for GRANT Object Permissions

http://msdn.microsoft.com/en-IN/library/ms188371(v=sql.105).aspx

Try converting it to int and sort.

Basically log is some works in circular motion, once the log file is full it will try to over write the backed up log or before full backup db point...

happy to help

Hello,

Use events like Stored procedures and TSQL.

sub events as per your needs.

vinu512 (4/24/2013)

Thanks, so in simpler words it means I cant get the data back...right???......All...

Follow the link this might help

http://www.red-gate.com/messageboard/viewtopic.php?t=4240

give some more details like.

1. Stand alone server means application and DB are in same server or separate DB server.

2. what is memory utilization...

Hello,

Do you have full backup taken every day , if it is try that before delete and recovery to the max you can.