...and aonother idea after seeing jeffs code:

why not create a view with your select statement (check distinct and joins) and

WHERE (ET.iSiteId = @locSITEID)

AND (ETS.iShowId = @locSHOWID OR @locSHOWID IS...

to avoid select permissons to tables i always do the following with dyn sql code:

just generate the where clause in the ui (if the tables stay the same) and call...

as far as i know: yes 🙂

because the indices, PKs and FKs are stored in the sys.sysobjects table in every database and this table is not copied to the other...

and you will do the copy only once or many times?

if you create the table itselfs on the other database one time you can append new data from the large...

thanks. i will check out the articel a little later because it is rather long ;))

but is it right that i only can find out that an error occurs and...

thanks.

yes, i know this and i already tried it as i mentioned.

but 1) the desintation server is sql2000 and 2) it doesn'work 😉

it works with example from knowledge base...

you can once recreate the table with the indices and then copy the data all the time with appending records.

for what reason you want to copy the table, maybe...

hi,

i had the same problem. sql server trigger does not affect all rows when i updated more than one row a time.

what i do now is to run a...

hi patrick,

i totally agree with elisabeth.

in my opinion it is no good idea to give a user permission to tables because of security problems.

a proc creates an execution...

hi,

if you use import/export wizard, the indices are not copied because they are stored in sys table in sys.sysobjects and this table is not copied.

what you can do: script your...

hi,

there are many different scenarios to backup a database.

be sure that recovery model is set to full backup (if not, you can change this in the properties of the...

i have no idea about service broker... 😀

do you think i should try to run a job every minute to synchronise data with the sql2000 server?

thank you for your ideas.

i don't think that there are connectivity problems in the meaning of lost connectivity, because both sql servers are in the same network and it...