No, but I have noticed that sometimes I've logged in and want to reply to a post, but the post asks me for my login and password.

I've learned to keep...

Start off by creating scripts that just retrieve information (SELECT). Create scripts that let you find out what type of data is in the database. Get creative with your scripts....

If you are shutting down SQL Server anyways and planning on moving the files (which it appears you are doing), then yes. Detach all the databases. Copy (or just move)...

No and Yes.

You can't run one BACKUP DATABASE command and have it backup ALL databases.

You CAN create one JOB (Enterprise Manager, Management, SQL Server Agent, Jobs) and in the job...

You really need to back it up. Backing up the transaction log also 'shrinks' it.

You should be doing full backups also.

With the install of SQL Server, you should also have...

What database?

The Transaction Log (TL) for the Master database CANNOT be backed up. It's 'locked' into SIMPLE Recovery mode.

For other databases, in Enterprise Manager, right click on the database, select...

What are you using for authentication?

SQL Server and Windows Authentication or Windows Authentication ONLY

If it's Windows Authentication, his SQL Server login AND password MUST be the same as his Windows...

Excuse me...my last post was wrong.

Is your SQL Server Agent Service running? Is it set to run all the time? The SQL Server error logs require the SQL Server...

In Enterprise Manager, right click on the SERVER. Select Properties, go the Security tab and check what AUDIT LEVEL is set to...I'll bet it's set at NONE.

-SQLBill

Are there any errors in the Windows Event Logs for the same time as the SQL errors?

-SQLBill

korotky,

You can not restore a SQL2000 database onto a SQL7 server.

You can restore a SQL7 database onto a SQL2000 server.

SQL2000 is backwards compatible with SQL7, but SQL7 is not forwards...

There's a difference between DBO and DBO privileges.

DBO 'maps' to SYSADMIN privileges.

DBO privileges can be given to any login.

A login needs SYSADMIN privileges to create anything as DBO (it's automatic).

A...

Use an Application Role. Refer to Books OnLine (BOL), use the INDEX tab and enter:

roles-SQL Server, application

Then choose the option for title: Establishing Application Security and Application Roles.

-SQLBill

What do you mean it's not keeping logs?

A couple of things to check....

1. when it was set up were the logs 'directed' to another drive? Use Enterprise Mangager (EM), right...

I liked the article, especially the description of how to put in the informative directions using the PRINT command. I'm going to go through my sp's and see where I...