Thanks Jeff, appreciate it.

Thank you everyone!

I appreciate all answers.

hi jeff,

Cannot insert the value NULL into column 'City', table 'DB_61318_itweb.dbo.Location'; column does not allow nulls. INSERT fails.

<code>

create table country(country_code nvarchar(2), country_name nvarchar(255))

create table states(country_code nvarchar(2),state_code nvarchar(20),state_name nvarchar(255))

create table weblocations...

The thing with sql server is that when u are playing with mixed mode.

you need to be aware if you change mappings for asp.net web applications.

Database in file location AppData....

David, you helped me.

Best thing is to goto security and login windows authentication

user sa make sure mappings are all granted

CREATE USER [sa] FOR LOGIN [sa]

GO

This is correct but I am try to set mixed mode back.

SQL instance from windows authentication to mixed authentication & then restart SQL services to get it working.

ALTER LOGIN sa...

Windows could not start service sql agent express on local computer

Error 1067

===================================

Cannot connect to OWNER-PC.

===================================

Login failed for user 'sa'. (.Net SqlClient Data Provider)

------------------------------

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------

Server Name: OWNER-PC

Error Number: 18456

Severity: 14

State: 1

Line Number: 65536

------------------------------

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException...

This is not my backup strategy. The thing is if one user wants to manipulate the report it can be loaded in memory without touching the database. How would u...

because my boss wants to store each report definiton in a database. That each report's xml is stored in a string ntext in a database.

So what should I do?

i think i got it

INSERT INTO tblFinancialContact (

[FinancialContactID],

[ProviderID],

[FinancialContactPrefix],

[FinancialContact],

[FinancialPosition],

[FinancialPhone],

[FinancialExtension] ,

[FinancialFax] ,

[FinancialEmail]

)

SELECT ROW_NUMBER() OVER (ORDER BY ProviderID) AS Row,

[ProviderID],

[FinancialContactPrefix],

[FinancialContact],

[FinancialPosition],

[FinancialPhone],

[FinancialExtension] ,

[FinancialFax] ,

[FinancialEmail]

FROM dbo.tblServiceProvider

SELECT ROW_NUMBER() OVER (ORDER BY ProviderID) AS Row,

[ProviderID],

[FinancialContactPrefix],

[FinancialContact],

[FinancialPosition],

[FinancialPhone],

[FinancialExtension] ,

[FinancialFax] ,

[FinancialEmail]

FROM dbo.tblServiceProvider

now how do I add the insert?

SELECT

(

[ProviderID],

[FinancialContactPrefix],

[FinancialContact],

[FinancialPosition],

[FinancialPhone],

[FinancialExtension] ,

[FinancialFax] ,

[FinancialEmail])

FROM dbo.tblServiceProvider)

SELECT ROW_NUMBER()

OVER (ORDER BY ProviderID) AS Row

stuck

SELECT ROW_NUMBER()

OVER (

SELECT

[ProviderID],

[FinancialContactPrefix],

[FinancialContact],

[FinancialPosition],

[FinancialPhone],

[FinancialExtension] ,

[FinancialFax] ,

[FinancialEmail]

FROM tblServiceProvider) AS Row

not sure how to do this?

nice job!