Not exactly sure what's going on, but it seems that you need to use a stronger password for the sa account than you tried initially. You need some lowercase...

Welcome to SQL Server!

You want to set up column constraints.

Here's a decent article describing contraints with a few examples.

http://www.mssqlcity.com/Articles/General/using_constraints.htm

Set the recovery model to simple

Run a full backukp.

run the DBCC command shrink file

DBCC SHRINKFILE (FileName, TargetSize)

FileName is the logical name of the file, TargetSize is the size in...

I'd suggets physically going to the SQL server box and setting yourself up an administrator account for the SQL Server. Next, find out what the password is for sa....

Do you have a full UNC path to the database. If you use a mapped drive, the job will work when run manually, but not when it is scheduled...

Thanks for the information Fred, it was very helpful.

Only problem Microsoft isn't very helpful.

You Can't restore a db from a 2005 SQL server to a 2000 SQL server,...

I believe the account used for the profile has to be a public email account, and the credentials used for the relay have to match the public account used for...

I'm running 64 bit SQL Server 2005 Standard on a Dell 64 bit machine running Windows Server 2003 and DB mail works just fine. The only trick I found...

Has anyone created their own log shipping process between a 2005 and 2000 implementation? I also am stuck with Standard versions of these products and would like to set...

I'm running 64 bit SQL Server 2005 and my Database Mail works fine.

I found configuration to be pretty straight forward.

The only problem I ran into was I didn't...

You could also set up @userid as a parameter for the report and capture the users userid value (User!UserId) when he/she logs in initially.

The user will still be prompted for username password even when using windows authentication. It just keeps you from having to manage a lot of usernames and passwords, by...

If you're having so much trouble with SSIS, why not run a normal dts from the enterprise manager if you're more comfortable with that. I have three dts packages...

I spent a good part of two weeks looking for a 64 bit MySQL driver for a SSIS package, to no avial. I ended up having to an old...

I do believe that you have to put the actual email address in that field, not a name for the server to resolve.

I have multiple operators set up, so I...