Instead of using a Maintenance Task, why not simply create an SSIS package that performs the backup. It is very simple to write a package. I have never relied on...

I would create a simple SSIS Package and schedule the package to fire off. But keep in mind that you need to have the SQL Service running under a domain...

I always drop the "sa" account, and re-create it and assign no permissions and assign it to public group

SQL BOL

System Administrator (sa) Login

System administrator (sa) is a special login provided...

you can create your own schema, and see everything that is in the database, the tables, the constraints, everything.

Since you posted this in SQL 2005, I am assuming that you...

You should never use the sys admin account for anything. That is only for backwards compatibility. Not sure why it is even still in here.

Create a simple SQL user account...

in the Execute SQL Task command area, type the name of the stored procedure and the parameter variable value

ie....

exec INS_NewColor 'purple'

That is it.

In the sproc you should have code that...

SSMS or Enterprise manager is only a client, like a web browser. you do not have to be connected to the Internet to open a web browser.

So how do you...

When you are using SSMS, are you on the server, or on your workstation? Have you tried connecting from a different workstation, or from a different server?

We cannot tell much...

You can move the TempDB to another drive. You can shrink it a couple times a week if needed. Is this a 24/7 box? If not, bounce it a couple...

What I was talking about is this............

You need to use a domain account to run the SQL Service. You will not be able to connect to any file share using...

For one, you should not be using the sys admin account for anything. Create another account for back ups. Also, you cannot place the backup files onto a network drive,...

A trans log cannot actually get full. It can grow all the way to the capacity of the drive in which it resides.

You need to backup the database and truncate...

You can start in the sys.syslogins view in SQL 2005 and above. If memory services me correctly, there was a syslogins table in SQL 2000. I do not have a...

I believe the SQL BOL are the best.

Andrew SQLDBA

Thanks Matt

Appreciate your explanation. You know, some things in SQL are sometimes difficult to explain, although you know the answer or how it works. It is at least for me.

Andrew...