The tough part about this issue is that the difference between US and UK currency changes. How are you going to handle that?

Anyways, there's two ways to do what you...

What do you mean by "scrambled"?

1. Encrypted?

2. Rows mixed up (ie. original 1,2,3,4,5 - scrambled 4, 5, 1, 3, 2)?

3. Something else?

-SQLBill

Restricting Views should work the same way as restricting Stored Procedures, Tables, etc.

Here's the easiest way, in Enterprise Manager, drill down to the database. Expand the database. Click on Views....

One other thing usually forgotten:

The full UNC path includes two slashes (//) before the server name.

-SQLBill

When backing up to a network drive, you need to remember/check the following:

1. Using the command tool, PING the system that you will be backing up to.....this will ensure you...

It's probably the MDAC that is missing. Go to Microsoft's web site and search for MDAC. Find the latest version, download it and just install it on the server with...

This isn't the exact error, but check this out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;327424

Are you using network library protocol?

http://support.microsoft.com/default.aspx?scid=kb;en-us;312948

I suggest applying the latest MDAC on each of your systems. But first download Component...

I'm not sure you can do that. TEMPDB is created using MODEL as a template (in fact, every database is created by using MODEL as a template).

Check to see if...

How big is the database that fails the backup? (Could be timing out)

Are all the databases backing up at the same time or one after the other? (again, could be...

Any errors in the Windows Event Viewer logs?

Would you please re-check permissions and confirm that you have permission to access the database, the table and to alter the table?

-SQLBill

On the server with SQL Server installed:

Open Enterprise Manager

expand the tree until you see the instance

right click on the instance

select properties

on the General tab, click on Network Properties.

In the...

Under Start>Programs>Microsoft SQL Server can you find:

Books OnLine

Query Analyzer

I'm guessing they aren't there either. Those (and EM) are installed as part of the Client Tools. They are usually installed with...

Yes, it would. Eventually. Shrinkdatabase and Shrinkfile do not work immediately.

It will take place, but for the transaction log, the inactive portions have to be located at the end...

Not related to your problem, but one thing to think of when backing up over a network.

Who is responsible for maintaining the network? Will it be up when your...

quote: but it's still not seeing any drives other than the local c$ and d$.

Those are shared drives. The drives you are attempting to access - are they shared also?

-SQLBill