Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server 2000 backup device
- Thread starter glealv
- Start date
NoCoolHandle
Programmer
This is because you can only back up to a local filesystem in SQL2000 instance.
In 7 you could fudge a local disk mapping //pc/share to a drive letter, but 2000 will refuse to do that.
You need to backup to a local disk (raid is ok) and then copy the backup file to the network location..
HTH
Rob
In 7 you could fudge a local disk mapping //pc/share to a drive letter, but 2000 will refuse to do that.
You need to backup to a local disk (raid is ok) and then copy the backup file to the network location..
HTH
Rob
- Thread starter
- #3
- Thread starter
- #4
Hi, I am wondering why this SP does not return any rows when executed from Access 2000?
CREATE PROCEDURE [dbo].[UspContaks] @clyent nvarchar(7) AS
select *
from tabContacts
where ClientID = @clyent
order by ClientID, ContactKey
GO
Access 2000 VBA:
conLocal.Open "Provider=SQLOLEDB;Server=HXXPFSRV08;Database=CustService;Trusted_Connection=Yes"
conLocal.Execute "UspContaks 'Y338032'", lngRows
CREATE PROCEDURE [dbo].[UspContaks] @clyent nvarchar(7) AS
select *
from tabContacts
where ClientID = @clyent
order by ClientID, ContactKey
GO
Access 2000 VBA:
conLocal.Open "Provider=SQLOLEDB;Server=HXXPFSRV08;Database=CustService;Trusted_Connection=Yes"
conLocal.Execute "UspContaks 'Y338032'", lngRows
- Status
Similar threads
- Locked
- Question
