quote:

---

The error that I get is a crystal reports error. Its "CrystaL Reports Error 533: Unable to open Database"

---

Sure you can.

restore database pubs from disk = '\\servername\sharename\pubs.bak'

Make sure SQL Server service account is a domain account and able to read the files from the share.

quote:

---

Can anyone of you tell me how to check what version of MDAC I am running and how to roll back a...

Check the dependencies with sp_depends before renaing the object.

Adding the IDENTITY property to an existing column actually goes by creating a new table with same structure as original table with identity property defined, copy data from original table,...

Just an example, Someone may have better solution.

use northwind

go

declare @cmd sysname

declare @tblname sysname

declare @ret int

select @tblname = 'products'

select @ret = count(*) from pubs.dbo.sysobjects where name = @tblname and xtype =...

Neither SQL Server 2000 nor SQL Server 7.0 supports adding the IDENTITY property to an existing column by using a single T-SQL command such as ALTER TABLE <table_name> ALTER COLUMN...

Right click your maintenance plan --> maintenance plan history to see any errors.

You can also log the errors into report by double click your maintenance plan --> reporting tab -->...

SQLBill,

Thanks again for clarification. That is exactly what I expected you are accessing a non-administrative share.

Frank,

Thanks for the info. I will try it.

quote:

---

However, the administrator can provide access to it and if you know it exists and have share permissions on it you can...

EXEC sp_MSforeachtable 'sp_spaceused ''?'''

You still need some manual works in my suggestion.

1. Backup database and rename it.

2. Generate scripts for all database objects.

3. Replace varchar with nvarchar in the scripts.

4. Create new database...

Run one step at a time to find out which step are causing the problem and post the script/SP of that step here see whether we could help out.

quote:

---

While I am doing the full backup across network, do I need to stop the transaction log backup?

---