True too. 80 MB is nothing. I have logs anywhere between 2 - 10 GB in size.

Create SQL Job and schedule it to run hourly. Add one step to it to shrink transaction log file for your database.

There is also option on each database if you...

It all depends what you want to accomplish. You need to look what is your RPO objective first.

let say that you promise your clients that you will not loose...

Either change character set or use N before posting data into the field. You insert would look like

insert into Temp (desc) values (N'Test').

Lucky you. I have the same issue and I can not seem to find resolution for it.

Well... Check how many databases you have. There is a mention on MS site that attached to sysperfinfo table. It may not work right if number of databases exceeds 99.

One reason would be to gain some performance. I have separate volumes for mdf and ldf files consisting of multiple drives. LDF file is is the append mode most of...

it will not stop growing after reboot. YOu need to shrink you log file after you take backup of it. That will make it small again.

It's more addition to the reply posted before. I would like to know whether I need to pay for casino or my name is included somewhere. Where would I find...

I'm not sure where SSC should show up, but I have mentioned in the registration SSC code as well as referal radio button. However, none of them were printed on...

Agree with Siva. I had to use the same trick. It looks like MS SQL is not really in favor of "-" anywhere in names or paths. I have had...

I believe in having naming conventions, but also documentation of desing and naming would be a big help. It would be nice to see somewhere a standard developed to use accross...

One more addition from MS FAQ on Licensing...

Q.

What is SQL Server 2000 Developer Edition and how is...

Per Microsoft

"Take advantage of new pricing for SQL Server 2000 Developer Edition. You can now license SQL Server Developer Edition for only $49.95 US.

You can obtain development licenses...

Kathy,

I think there is an error in batch file. I believe it should look like

NET STOP SQLH2PerfCollector

C:\SQLH2\SQLH2.exe /CC:\SQLH2\H2ConfigPerf.xml

NET START SQLH2PerfCollector

Otherwise performance file is locked by the service and SQLH2...