As always, it depends!

What are your goals for this replication ?

What's the db relationship for your 2 sql2005 instances ?

(duplicates or not) and how are they duplicated at SQL2008 ?

-...

Indeed.

You need another kind of temp table (#mytable) in stead of a table variable (@mytable) to

be able to use it in combination with exec !

--edited--

Regarding the nested exec...

That would mean...

What you are trying to do is to compose dynamic sql (because objects change).

Must read all time reference: http://www.sommarskog.se/dynamic_sql.html

Any query needs a fixed object name to act on.

If you still...

- start a trace to figure out what 's going on.

(you can have the trace start a new file every xMB, and so if the issue didn't occure during...

bhindla (3/25/2009)

---

Well, I'm glad it's working out for you . . . not so much for me.

I'm running (or trying to run) SQL2K8 on W2K3 SP2. I know SQL2005...

As already stated, double check you are pointing the SMO properties to the specifics you are querying, scripting, modifying,... !!

Opting for the left join, would mean a vertical split of the data into a number of tables.

As always ... it depends ... mainly on your performance goals, but as...

Keep in mind SQLAgent has settings (activated by default) for job history.

- Total number of rows

- Max number of rows per job

If you have many jobs, you may be hitting...

Never mind, I created a carthesian resultset because I didn't include all elements to be compared in the ON-clause of the join.

Now it's working a bit better, but still doesn't...

I got things working a little bit :crazy:

I have attached the sample data and the needed queries.

The problem is the comparison query never ends ....

This server has +/- 1400 shares...

You need to specify :

OR new file locations as proposed above.

OR use the 'replace' keyword to overwrite an existing database !

I advise to always specify the target file locations, so...

You may want to work with a delete loop of smaller chuncks of your data.

Keep in mind your logfile may grow during this operation.

I don't know where I got this...

For sqlserver I suggest you use the bigest allocation unit size your windows supports.

It will be the smallest unit of allocation for any file(extend) on that volume.

So the smaller it...

Thank you Jacob.

I'll give it a try.

Johan

Kaushalendra Singh (3/22/2009)

---

first we can change the password the then ran the jobs in sql server 2000.

folowing this staps

open the notepad

copy

then save the text file at changespassord.bat in c...