I couldn't find one at USPS's website. But if you GOOGLE for "ZIP CODE" Database, there's quite a few choices.

-SQLBill

I'm not positive, but I believe you can get one from the US Postal Service.

-SQLBill

Depends on what you are really trying to do....you could always create a VIEW of your database with the VIEW having different column names to hide the actual names.

-SQLBill

To backup what Steve says....

NULL basically means "I don't know what this is".

So, when you compare a NULL to 0....(WHERE NULL 0), SQL Server says 'I don't know if...

One other thing, go to Enterprise Manager, expand until you see your database. Right click on your database, select Properties. Go to the Transaction Log tab. There will be a...

1. What are you doing when it grows?

-As dcpeterson says, index rebuilds will do this. Do you have a maintenance plan running?

2. Are you doing backups (Full and...

RETAIN DAYS and EXPIRE only work for tape backups or backups that are saved with dates for the file name. If you keep reusing the same backup file, RETAIN DAYS...

There may be a big problem. What do you want your timestamp column to do? What datatype is the timestamp column - is it TIMESTAMP or DATETIME?

Timestamp datatype is...

How are logins being done?

Is your SQL Server set to use Windows Authentication only or is it set for Mixed Mode?

Is the user's login set for Windows Authentication...

As Steve says, SysAdmins handle the OS and network (sometimes there is a different Network Admin) and the Database admins handle SQL Server.

For example: I can assign someone a SQL...

Due to applications being used, I need the database name to remain the same. This way the only thing that needs to be changed is an ODBC connection to the...

BOL is the Books on Line. The SQL Server Help files.

-SQLBill

Suggestion:

Create a script that shrinks the files and then does the backup. Supply the script to your clients whenever you need them to send you backup files.

-SQLBill

So you aren't doing the restore on the original system?

Did you copy the tape backup to the same drive location as on the original server (to N'D:\SQL Data Files\RSMS\Backups)?...

Why don't you just run sp_spaceused without the updateusage part?

-SQLBill