马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?站点注册
×
我是初学者,实际中遇到了些困难,请大家帮帮忙。我的服务器环境是unix ware 7+sybase 11.92 使用sybase 客户端的sql advantage 执行sql语句,出现如下错误:
Server Message: Number 156, Severity 15 Line 7: Incorrect syntax near the keyword 'use'. (1 row affected) Server Message: Number 5146, Severity 16 Line 6: The VDEVNO of 10 is out of range. The maximum VDEVNO allowed is 9. Server Message: Number 1804, Severity 10 Line 1: There is no disk named 'tempdb1'. Checking other disk names. Server Message: Number 5009, Severity 16 Line 1: ALTER DATABASE failed. Some disk names listed in command were not found. Check that names exist and are spelled correctly before re-running command
请问这些server message 返回的这些错误号及级别号代表什么意思?语句问题出在哪里。有没有一些参考资料专门介绍 这些返回数字是代表什么意思的?还有一个问题,创建一个数据库一定得先创建数据库裸设备吗? 谢谢!执行的语句如下:
disk init name = "tempdb1",use master go
declare @vdevno int select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1 from master.dbo.sysdevices d, master.dbo.spt_values v where v.type = 'E' and v.number = 3
disk init name = "tempdb1", physname = "/home/sybase/data/tempdb1", vdevno = @vdevno, size = 51200 go alter database tempdb on tempdb1=100 go |