We have three Adimistrators so any of the three admin can restart the server.

They would have logged in their account and restarted the server it is difficult to remember for...

In my differential backup plan I unchecked the Master db. Now the differential backup of all the databases is going as scheduled. I wonder what the master db has to...

First I have defined the path for differential plan but If I edit any of the features in differential plan without altering the path the path automatically resets to the...

When I checked the log file viewer I get the following message.

1>Database differential changes were backed up. Database: Guardian, creation date(time): 2008/06/20(01:32:30), pages dumped: 395, first LSN: 55917:5325:1, last LSN:...

Thanks for the solution. I will redesign my maintainance plan.

I know it is always better to take a backup first and delete the older file.

But as I said I have a space constraint so cannot do that. Anyway...

Sorry the first logic was wrong the second is working fine.

Thanks

The logic is not working.I am getting wrong results.

The main cause is on Thursday morning I insert about 10 million of data to a table. Using the sysfiles I can view that the log file has grown then...

Do changing the log_reuse_wait_desc to 'CHECKPOINT' or any other value helps in checking the growth of the log file?

The Log_Reuse_Wait_desc is 'nothing' for this database.How to make the transaction log truncate at checkpoints? What is the difference between shrinking and truncating the file.

SUPERB!! this is really amazing just one query, this is the reason I like this forum. I have done this but it looks very complicated to the above query. THANKS.

Is tally table the only option to get the results? I do'nt want to use any temp tables in my procedure.

Since by the knowledge I got by reading these two replies I think there is no harm in using numeric but Bigint is the always better choice than numeric.

The reason why I want create a view is that my application has around

35 procedures where in each of these procedures I have used the query.

Select t1.column1,t2.column2 from table1...