one more thing ive just realised. ok, i can get the number of rows in each of those tables, but i when i try to use that number when inserting...

ive tried that with this code

declare

@tableName varchar (50)

Declare

@command varchar(50

so near yet so far. thank you.

thank you. very helpful. much appriciated.

and whats the difference betweeen blocking and deadlock? is it that deadlock will never end unless sql server or the admin kills a process, and blocking will end when the...

got it sorted, i was using the correct connection type, there was a connectivity issue over my network.

its to an sql instance on a server i think.

i got the link to go ok, but when i make any changes to tables on the linked server, althought it...

the sp_Who provides the info i need.thank you for your reply.

thank you phil, that worked a treat. dont know how i was so stupid not to see that, but i suppose these things can be overlooked ( especially in a...

i took the easy way out and simply done a dts on the table from production to the table in test server that i deleted all data from. not the...

ive played around with that statement also and it returns nothing.thanks all the same

im afraid that made no difference

this sounds very dumb, but how do i search for empty cells?

ive tride

select * where col5 = ' '

select * where col5 = ''

select * where col5 = '%%'

none work.

im...

yea, when i invert the query the null values are still returned. why is this? how do i sort this ?

keep getting this error

Msg 18452, Level 14, State 1, Line 1

Login failed for user EUROPE\v-fintag'. The user is not associated with a trusted SQL Server connection.

even though i know...