RESTORE FILELISTONLY

FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_07_01_051239_6046267.bak'

GO

Closing Post moving to new

RESTORE DATABASE PrismDataBillingTest

FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_06_26_130000_9108635.bak'

WITH MOVE 'PrismData_Data' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Data.mdf',

MOVE 'PrismData_FG2_0'TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBilling_Indices_0.ndf',

MOVE 'PrismData_FG2_1' TO' D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Indices_0.ndf',

MOVE 'PrismData_FG1_0' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_FG1_0.ndf',

MOVE 'PrismData_FG1_1' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismData_FG1_1.ndf',

MOVE 'PrismData_Log' TO 'F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Log.ldf'

Msg 3154, Level 16, State 4, Line...

RESTORE DATABASE PrismDataBillingTest

FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_06_26_130000_9108635.bak'

WITH MOVE 'PrismData_Data' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Data.mdf',

MOVE PrismData_FG2_0 TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBilling_Indices_0.ndf',

MOVE PrismData_FG2_1 TO' D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Indices_0.ndf',

MOVE PrismData_FG1_0 TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_FG1_0.ndf',

MOVE PrismData_FG1_1 TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismData_FG1_1.ndf',

MOVE PrismData_Log TO 'F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Log.ldf'

Msg 102, Level 15, State 1,...

I try:

RESTORE DATABASE PrismDataBillingTest

FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_06_26_130000_9108635.bak'

And I get this?

Msg 3154, Level 16, State 4, Line 2

The backup set holds a backup of a database other than the existing 'PrismDataBillingTest'...

I tried this and I got nothing:

SELECT * FROM ::fn_listExtendedProperty

(NULL,NULL, NULL, NULL, NULL, NULL,NULL)

I tried this and it only returned the value for the table:

SELECT *...

Correction: Extended Properties for a table?

I figured it out, a no brainer.

Simply add the property and the change is automatically made.

Now I have to find out how I can script the existing extended properties and...

The following article answered my questions:

https://www.mssqltips.com/sqlservertip/1619/build-a-sql-server-data-dictionary-with-the-extended-properties/

The wizard...

I execute the following query:

SELECT DISTINCT ID, Name, Abbreviation, CountryID

FROM Postal_StateProvince

WHERE CountryID = 2

It returns the following values:

IDNameAbbreviationCountryID

52AlbertaAB2

53British ColumbiaBC2

54ManitobaMB2

55New BrunswickNB2

56NewfoundlandNL2

57Northwest TerritoriesNT2

58Nova ScotiaNS2

59NunavutNU2

60OntarioON2

61Prince Edward IslandPE2

62QuebecQC2

63SaskatchewanSK2

64Yukon TerritoryYT2

It return the following error:

"Cannot insert...

John Mitchell-245523 (6/8/2016)

---

Welsh Corgi (6/8/2016)

---

I am getting a Primary Key Violation when Loading a Table.

I queried the source table and there is only one record with value of the primary...

I added a distinct on the lookup table and I did not get duplicates.

SELECT DISTINCT Catevent.*

FROM CatEvent

Inner join CatEventArea on CatEventArea.CatEventID = CatEvent.CatEventID and CATEventArea.CountryID =

Thank you Sir.

Thanks. I checked it that does ot apply.

Select tblNexus.* from TblNexus WITH (NOLOCK)

Inner Join PrismClients WITH (NOLOCK) on TblNexus.PrismclientID = TblNexus.PrismClientID and PrismClients.CountryID = 2

It just happened with another...

I recreated the table and it worked.:crazy: