تقييم الموضوع :
  • 0 أصوات - بمعدل 0
  • 1
  • 2
  • 3
  • 4
  • 5
مشكلة في اسكربت SQL
#1
حملت سكربت لقاعده بيانات وعند تحويل الاسكربت لقاعده
بيظهرلي الاخطاء دي ما الحل
Database 'SaleMsg 911, Level 16, State 1, Line 1
sDB' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 8
There is already an object named 'Accounts' in the database.
Msg 2714, Level 16, State 6, Line 22
There is already an object named 'CompanyInfo' in the database.
Msg 2714, Level 16, State 6, Line 39
There is already an object named 'CustomersAndVendors' in the database.
Msg 2714, Level 16, State 6, Line 58
There is already an object named 'Drawers' in the database.
Msg 2714, Level 16, State 6, Line 73
There is already an object named 'InvoiceDetails' in the database.
Msg 2714, Level 16, State 6, Line 97
There is already an object named 'InvoiceHeader' in the database.
Msg 2714, Level 16, State 6, Line 131
There is already an object named 'Product' in the database.
Msg 2714, Level 16, State 6, Line 151
There is already an object named 'ProductCategory' in the database.
Msg 2714, Level 16, State 6, Line 167
There is already an object named 'ProductUnits' in the database.
Msg 2714, Level 16, State 6, Line 187
There is already an object named 'StoreLog' in the database.
Msg 2714, Level 16, State 6, Line 209
There is already an object named 'Stores' in the database.
Msg 2714, Level 16, State 6, Line 223
There is already an object named 'UnitName' in the database.

Completion time: 2020-03-31T10:07:49.0672251+02:00
الرد }}}
تم الشكر بواسطة:
#2
اول سطر بيقول ان قاعدة البيانات غير موجودة او الاسم غير صحيح
باقي السطور بتقول ان الكائن المطلوب انشاؤه موجود بالفعل

لحل المشكلة :
تأكد أولا من اسم قاعدة البيانات المطلوب انشائها
ثانيا اضف سطر الحذف للكائن ان وجد وإعادة انشاؤه
الرد }}}
تم الشكر بواسطة: asemshahen5 , ابراهيم ايبو , محمد كريّم



التنقل السريع :


يقوم بقرائة الموضوع: