1
Vote

Running Script at Azure Database

description

I have pasted the AdventureWorks2012ForSQLAzure_Schema into my AZURE database
I selected the estimate plan and after it finished running I get hundreds messages.

Could someone explain why I am having so many issues.

Msg 2715, Level 16, State 3, Procedure uspUpdateEmployeeHireInfo, Line 373
Column, parameter, or variable #7: Cannot find data type dbo.Flag.

Msg 2724, Level 0, State 2, Procedure uspUpdateEmployeeHireInfo, Line 373
Parameter or variable '@CurrentFlag' has an invalid data type.

Msg 2715, Level 16, State 3, Procedure uspUpdateEmployeeLogin, Line 422
Column, parameter, or variable #6: Cannot find data type dbo.Flag.

Msg 2724, Level 0, State 2, Procedure uspUpdateEmployeeLogin, Line 422
Parameter or variable '@CurrentFlag' has an invalid data type.

Msg 2715, Level 16, State 6, Line 764
Column, parameter, or variable #2: Cannot find data type dbo.Name.

Msg 208, Level 16, State 1, Procedure vStoreWithDemographics, Line 798
Invalid object name 'Sales.Store'.

Msg 2715, Level 16, State 6, Line 836
Column, parameter, or variable #2: Cannot find data type dbo.Name.

Msg 2715, Level 16, State 6, Line 871
Column, parameter, or variable #3: Cannot find data type dbo.NameStyle.

Msg 2715, Level 16, State 6, Line 897
Column, parameter, or variable #2: Cannot find data type dbo.Phone.

Msg 2715, Level 16, State 6, Line 916
Column, parameter, or variable #2: Cannot find data type dbo.Name.

Msg 208, Level 16, State 1, Procedure vStoreWithContacts, Line 947
Invalid object name 'Sales.Store'.

Msg 2715, Level 16, State 6, Line 989
Column, parameter, or variable #2: Cannot find data type dbo.Name.

Msg 2715, Level 16, State 6, Line 1026
Column, parameter, or variable #2: Cannot find data type dbo.Name.

Msg 2715, Level 16, State 6, Line 1042
Column, parameter, or variable #4: Cannot find data type dbo.Flag.

Msg 208, Level 16, State 1, Procedure vStoreWithAddresses, Line 1075
Invalid object name 'Sales.Store'.

comments