INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'AK', 'Alaska')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'AL', 'Alabama')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'AR', 'Arkansas')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'AZ', 'Arizona')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'CA', 'California')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'CO', 'Colorado')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'CT', 'Connecticut')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'DC', 'District of Columbia')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'DE', 'Delaware')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'FL', 'Florida')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'GA', 'Georgia')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'HI', 'Hawaii')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'IA', 'Iowa')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'ID', 'Idaho')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'IL', 'Illinois')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'IN', 'Indiana')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'KS', 'Kansas')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'KY', 'Kentucky')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'LA', 'Louisiana')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'MA', 'Massachusetts')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'MD', 'Maryland')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'ME', 'Maine')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'MI', 'Michigan')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'MN', 'Minnesota')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'MO', 'Missouri')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'MS', 'Mississippi')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'MT', 'Montana')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'NC', 'North Carolina ')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'ND', 'North Dakota')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'NE', 'Nebraska')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'NH', 'New Hampshire')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'NJ', 'New Jersey')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'NM', 'New Mexico')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'NV', 'Nevada')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'NY', 'New York')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'OH', 'Ohio')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'OK', 'Oklahoma')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'OR', 'Oregon')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'PA', 'Pennsylvania')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'RI', 'Rhode Island')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'SC', 'South Carolina')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'SD', 'South Dakota')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'TN', 'Tennessee')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'TX', 'Texas')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'UT', 'Utah')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'VA', 'Virginia')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'VT', 'Vermont')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'WA', 'Washington')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'WI', 'Wisconsin')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'WV', 'West Virginia')
INSERT INTO States (ISOCode, StateAbbr, Name) VALUES('US', 'WY', 'Wyoming')
петък, 24 октомври 2008 г.
сряда, 27 февруари 2008 г.
Cannot add diagram to MSSQL 2005 database
That works perfectly for me:
EXEC sp_dbcmptlevel 'genii2', '90';
go
ALTER AUTHORIZATION ON DATABASE::genii2 TO sa
go
use [genii2]
go
EXECUTE AS USER = N'dbo' REVERT
go
EXEC sp_dbcmptlevel 'genii2', '90';
go
ALTER AUTHORIZATION ON DATABASE::genii2 TO sa
go
use [genii2]
go
EXECUTE AS USER = N'dbo' REVERT
go
Абонамент за:
Коментари (Atom)