Running script on SQL 2022; "Cannot find data type dbo.ipaddress."

bshp / nps_accounting

Microsoft NPS SQL Accounting

MIT License

4 stars 6 forks source link

Running script on SQL 2022; "Cannot find data type dbo.ipaddress." #3

Open ItAdmin712 opened 1 day ago

ItAdmin712 commented 1 day ago

Trying to run these scripts on SQL server 2022. The IP Address fields cannot be created. The error is: Cannot find data type dbo.ipaddress.

Is there a different data type that could be used?

macn27 commented 1 day ago

@ItAdmin712 - you may want to look elsewhere for the script to setup the SQL database, although I'm sure that this script works well for some, I also had trouble with it. I would look further at the official Microsoft documentation specifically this web page - https://learn.microsoft.com/en-us/windows/win32/nps/sql-programmability#sample-stored-procedure I used the script there to create my database.