The corrected question, which is on the web site, is

CREATE TABLE E (eid int, mid int, en char(10) )

INSERT E SELECT 1,2,'Vyas'

INSERT E SELECT 2,3,'Mohan'

INSERT E SELECT 3,NULL,'Shobha'

INSERT E SELECT...

As mentioned you need to shrink the log, but you also need to set up log backups, figure out how large to leave the log, and monitor things.

I'd use Jeffrey's suggestion. You can't use a variable in the 3 or 4 part naming scheme.

Hard to stay in the top 5. Someone can answer a few hundred questions in a couple days and get up there.

The question is repeated when you click in the newsletter. If there is an issue, we will try to fix it as soon as we can.

The ORDER BY doesn't change...

If you (ya'll) want to write a book together or separately, Tony Davis of Simple-Talk is always looking for some to use in promotions. He has gotten them in print...

B-I-N-G-O

The question has been corrected to fix the typo and include an ORDER by clause.

main.denis, sorry we are not responding fast enough for you. It is the morning here, this...

Sample data of what is in the tables, and what the result should be. Not what you are getting with the query that doesn't work.

Simon was once trying to sell SQL Compare to a company and they questioned the value. He pulled out two phone books from different years and 100lb note. Said if...

Sounds like you need more drives. Also, storing backups on the same physical disk as data is a mistake. If it goes, you lose data.

Make sure you have enough space...

I thought an index was a scale for measurement. Isn't that why it's in all those performance questions?

Use CTRL+F5 to reload the page without cache. Windows caches the page a little too much sometimes.

the newsletters got messed up over the weekend as well. Tomorrow should have them going back out on schedule.

Only what's in the default trace. not sure how much information there is.

You can get a tool like ApexSQL Log to read the log itself if you have backups or...