either

select replace( SimID, '_000','')  FROM Course

or

select left(SimID,len(SimID)-4)  FROM Course

All depends how you want to do it , and what the data...

What is the backup device? Tape? Disk?

Is the device showing up in the EM under %Server% -> Management -> Backup?

Master, Msdb & tempdb do not allow it.

Per INF: Restore File and Filegroup Backups in SQL Server

SQL Server 7.0: This requires that the
TruncateLogOnCheckpoint option is not set and...

I generally breakup my Maint Plans into system DBs, User DBs (tran log BU), and IS DBs (simple recovery and SW control DBs).

The 3 day is to allow for weekends...

I've run into that on occasion. Couple of things to check:

• Any process still running in Access?
• Is a form open either in design-mode or hidden in the background?
• What else is running...

I would suggest that as you write the standards, you develop it as an HTML or indexed document.

In the document, you justify and give a basic guide on how to...

We use mostly delivered apps. I'm the DBA for Oracle, SQL, and Sybase ASA 8 databases. We also use a lot of Access front-ends to the delivered DB's as well...

The problem is that there are 7 db's on the one server and 22 on the other (note: avoid NetVision at all costs for now) not inlucing the SQL db's....

If you are using mixed mode authentication across a WAN with multiple domains on an undersized SQL server and/or unserized domain controller(s) and not a full up AD M$ network...

My misread - sorry .

But still, would it handle a view instead of the base table. There the view is an order by

Create View...

Is the table indexed?

Is it possible to create a view on the table...(i.e. Create View GenericReport as SELECT * FROM GenericReportBase WHERE UID= %userlogin% ) at login?

I was referring to :

Does the workstation/PC have a login in the SQL server?

If so did you do the autofix_login on that?

Actually, it probably is pulling from the sysobjects table. You'll have to figure out how to read that yourself.

The maintenance plan wizard simply builds the T-SQL jobs and schedules them. Go to the %Server% -> Database Maintenance Plans and build one. Then go look under Management - SQL...

As to what can happen -

The server fries its

• motherboard
• two drives in a raid set *
• the raid controlller *
• the NIC
  .

  Others include:

  • The trainer for the company logs the new users into the...