It was just a scenario on which I have a doubt..

So I can't specify the error message.

Suppose the size of the master database is 50MB

and that 50MB is full then...

As far as i know when the database in Simple Recovery Mode , check point is issued  depending on the recovery interval and when the T-Log is 70% full..

..hema

But sysprocesses contain only process id of the blocked process it doesn't contain the id of the blocking process.

How to get that? Actually I want to form a table with

the...

This command will give information about log space..

dbcc sqlperf(logspace)..

You will get the log size (the actual amount of space available for the log) and the log space used.It may be...

DTS Package is used for transforming the data and copying data from

source to destination .It is not used for deleting the data and more over there

will be no date control.So...

create a trace on that stored procedure and see

what is happening really...

..hema

Update the statistics and see..

..hema

Hi,

If you want to know whether the query is using a seek or a scan.

click on the query execution plan which will be on the  right side top

of the

Try that using a DTS Package..

..hema

yaah sure jeff,

1) If you specify 'set nocount on' then no messages will be sent to client

for eg. (1 row(s ) affected)..hence it reduces the network traffic.

2)You should not...

Update the statistics of the database and see...

I am not sure about this..but i hope it may work..

..hema

It is the no of reads and writes that are counted as the cost

You can use :

'sp_dboption' stored procedure to change the collation setting for the database..

..hema 

Limitations in stored procedure:

1) Use 'set nocount on'  at the beginning of the stored procedure and use

'set nocount off ' at the end of the stored procedure.

2) Don't use 'exec'...

Stored procedures will be faster than scripts bcoz when the stored procedures are executed once then their execution plan will be stored in the procedure cache.So there will be no...