Hi

Its difficult to understand vague terms such as same table and other table etc. You might want to consider rewording the post so that we get a better idea of...

The log file will grow as required and occupy as much space as needed. You need to check if the size its occupying is relevant within the scope of the...

How are u shrinking the file ? SSMS or DBCC ?

What message do you get when you try to shrink ?

You might want to go thru this document

http://www.google.co.in/url?sa=t&source=web&cd=1&ved=0CBcQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F6%2FF%2F8%2F6F84A9FE-1E5C-44CC-87BB-C236BFCBA4DF%2FSQLServer2008_LicensingGuide.pdf&rct=j&q=msdn%20sql%20server%20license%20pdf&ei=zYg_TumpOoqzrAfq7PkP&usg=AFQjCNES7vdR_6DWAugYignPX2rCWPFkOQ&cad=rja

The point being

1) Post the exact error message you see

2) 31/1/2011 = 31/1/2011 00:00:00.000 and not 31/1/2011 23:59:59.999

Have you considered point 2 in your logic ?

Have you checked for any bulk operations happening on the DB. Any recent deployments ?

Whats the auto growth setting for the log file for this DB?

Good to know. I wasn't referring to the installation folder as being corrupt , I meant the bootstrap file setup.exe.

They sure do 😀 , but its always fun trying to find a short cut.

There is a difference between account lock out and Disabled accounts , You need to have your DBA monitor the server to find out which of these is occurring. Or...

You could add the User defined function in the body of the proc so that the proc executes the UDF as part of its completion. However without knowing the actual...

Try restarting the sql services esp the SQL Browser service. Make sure TCP/IP is enabled in network configurations.

Do you face this issue every time your connecting using SSMS ?

Have...

This is just another option. You could easily have all these operations being performed as part of a simple bat file containing the FTP commands and have SSIS execute the...

There is a setup folder under the server folder as part of the installer. Here you will find the individual msi for each product such as SSRs , SSIS DTS...

Most likely its another process trying to connect using the wrong password. Since the issue has been occurring for a long time, I think the other process is still unaware...

If your using the report builder wizard there is a check box to include grand totals, select it and you will find a row at the end of the table...