Hi micky t.

I have done that and all seems fine now

thanks everyone.

not sure how to close this as resolved

Hi all

yes i agree, i am not sure about the left out join thats what has confused me a bit.

would this query provide the same results?

SELECT distinct a1.Netbios_Name0,

c1.SerialNumber0,

a1.Operating_System_Name_and0,...

thank you that worked a treat

HI ADMIN

CAN YOU CLOSE THIS TOPIC AS I HAVE FIGURED IT OUT AND DONT KNOW HOW TO MARK AS SOLVED OR CLOSE IT

THANKS

that works thanks very much for your prompt response

I have done that although this looks a little closer it comes up with the error

Incorrect syntax near 'Synergy_SAR_Raw'.

I have an update but still stuck around the bulk insert quotes part

i have passed in a variable

ALTER procedure [dbo].[importSAR]

@importedfile nvarchar(50)

and tried this

BULK INSERT newtable

FROM ''C:\inetpub\wwwroot\'' ''@importedfile''

WITH ( FIRSTROW...

Do you know of any free ones, when I have tried to look for some they all have to be paid for

thanks again

so does that mean my procedure I have encrypted is offically unreadable,editable even though I am the owner because I have not kept the original source???

right i have figured out how to encrypt my procedures by doing

alter procedure procedure name with encryption as

bla bla bla

now I have a procedure with a little padlock next to...

yeah it just comes up that the textheader is not available etc due to insufficient access rights so yeah looks like its encripted

also my other question , how would I...

hi there

Yes I am the sa on the box

thanks

Hi rollercoaster

thats fantastic I cant thank you enough, the problem ended up being a wrong datatype in one of the columns

thanks again

Hi there no im not getting any error messages it is just hanging, i am new to sqlserver, where would i locate the profiler and the sql error logs

thanks

thanks for that

enjoy your weekend