may i know what is the recovery mode for your database?

since you have transaction log backup every 2 mins, you can change your database recovery mode to Simple.

to shrink ur...

Would you like to include SQL:BatchComplete?

May be there is other option for you to check that. : )

Leo

It is not recommended to use DB login for your web application.

your DB will be easily hacked if you do so.

unless, you data is not important at all.

Leo

Please refer to SQL Server Books Online.

***********************************************

Function Invocation

Scalar-valued functions may be invoked where scalar expressions are used, including computed columns and CHECK constraint definitions. When invoking scalar-valued functions, at minimum...

can you explain more on this?

thanks.

Hi,

normally i dont pass in date time value from client.

in fact, i will pass in date time in string format.

for example, if i want dd/mm/yyyy, i will pass in...

Profiler don't need to pass in parameter.

Just open Enterprise Manager --> Tools --> SQL Profiler

Then, create a new trace.

I would suggest you to use the template trace there.

you can include execution plan under category [Performance].

of course, here are other features as well.

other than PerMon, you can create a profiler and let it run for 2 hours (during peak hour) to check what sp is actually running. however, this may slow down...

I strongly agree with you.

DBA role is very specific. This role is not going to be handled by a normal apps developer well.

Even though database will look more easy...

try this:

update your_table

set date_field = convert(datetime,

convert(varchar, getdate(), 106) + ' ' + convert(varchar, date_field, 108),

0)

Leo

you can use this command:

BACKUP LOG db_name WITH TRUNCATE_ONLY

DBCC SHRINKFILE (log_file_name, file_size)

this will truncate your log file as you want.

however, please check Books Online for detail description regarding WITH TRUNCATE_ONLY.

Leo