Create a device.
Error message:
Cannot create device 'DEVICENAME': no available virtual device numbers (vdevnos)
Solution:
exec sp_configure 'number of devices', 20
-- replace 20 with a number that is bigger than what it set now.
Cause:
There is a limit of maximum number of devices - you probably get to it.
Check the number of devices:
exec sp_configure 'number of devices'
See the devices in the server:
select * from master..sysdevices
No comments:
Post a Comment