Joseph's answers are good for the transaction logs for user databases, but the TEMPDB is designed to grow and not be backed up. Stopping and restarting the services rebuilds the...

Have you tried:

UPDATE tablename

SET columnname = @variable1 + @variable2

-SQLBill

How are you attempting to do the reindex?

There are two methods normally used. First is to drop all the indexes and then recreate them (DBCC DBREINDEX), the second is to...

I don't do this, but have you considered REPLICATION or Log Shipping instead of backups?

You can find out more about those in the Books OnLine, or do a search on...

Here's the issue:

NULL is unknown, it has no value. When you add something and NULL together the SUM is NULL. So 1 + 2 + NULL does NOT equal 3,...

One very important thing to remember:

RESTORE the database using WITH NORECOVERY, the RESTORE the first log WITH NORECOVERY, then the last log using WITH RECOVERY.

Oh, second thing to remember....if your...

How did you attempt to add the user?

I'm guessing you might have tried to create a new user instead of GRANTing access to the database to the existing user.

-SQLBill

The only log viewer/reader that I have heard about is from Lumigent. But according to their website it only works on 7 and 2000. But it 'appears' to imply that...

Your friend obviously entered something wrong during the install. Can we tell what that was? No. Unfortunately we weren't there when it was installed.

Do you know at what point the...

According to the BOL:

You can create views only in the current database. However, the tables and views referenced by the new view can exist in other databases or even other...

Yep Steve, that's the article I was referring to. For Jonathan and anyone else who might read this post and need the information - here's the link to the article:

This is a duplicate post and has already been answered.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=115242

-SQLBill

If you need to find out which port is being used by SQL Server:

On the server, open a command prompt (Start>Run type in cmd and click ok), type netstat -a

then...

Are you running AntiVirus programs at night? Are they checking the .mdf/.ldf files? If so, that may be causing your problem.

If you are running AntiVirus programs against your database, I...

Two words:

SLAMMER WORM!

The default of a blank password for the SA account was utilized by Slammer. The fact that so many people did not have the SA login protected made...