No the shortcut is on their desktop (points to an app on the server).

Hope that clears things up.

Phil.

Hi. I am inserting into a table. I did not check the keep identity option.

I have given up trying for now!! I will have a re-think.

Thanks for your time and...

I have been having a play trying to import data using SSIS but am unable to resolve errors;

Validating (Error)

Messages

Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column...

Thanks for your time. SSIS sounds like a plan.

Phil.

Thanks.

I might have to eat humble pie as I have tried to replicate same issue on other machines and have not been able to (have now updated my NVIDIA drivers)...

Hi.

Application runs on SQL

client-server

SQL Profiler running

What columns might be of interest?

If I have database A can I filter by database name?

Thanks,

Phil.

I ended up re-building the server then re-deploying...............

Phil.

Thanks guys. I manually re-mapped the FK Constraints as there were only 2 of them.

Phil.

Quick update. I ran:

ALTER TABLE [Test].[dbo].[StructureVersions] WITH CHECK CHECK CONSTRAINT FK_StructureVersions_Products

to re-add the FK Constraint. SQL returned error:

Msg 547, Level 16, State 0, Line 1

The ALTER TABLE statement conflicted...

Andras I have now managed to execute the delete statement after removing the FK Constraint.

I take it I reverse the NOCHECK before re-importing the data?

Phil.

PS: Thanks for the...

Andras just to note, if I use command Use Test then I am able to see the 'Database' drop down selector. However this is not usually visible? Can I make...

Hi Andras. The [dbo.] was a typo!!

I will have a play with your commands.

Many Thanks,

Phil.

Hi Andras.

I launch Management Studio then connect to the Server (Server Name: My Server) using the sa account. I then expand 'Databases' then select 'Test'

The Summary window displays:MY-SERVER\Databases\Test

If I...

Thanks for the reply. Tried to run that command against Products, sql returned error:

Cannot find the object "Products" because it does not exist or you do not have permissions.

Connected to...

Guys I found a usefull script that did just what I was after so I have attached it as I thought it might be of use to others.

Credit to: Gregory...