We always have 'sa' for actual db owner.

With application service accounts that created databases and dbobjects..

-On SQL2000 the attitude is like Jerry Hung stated.

-On SQL2005 those db are also altered...

I've also found some nice perf. info at http://www.ramsan.com/products/products.htm

If I get the chance, I'll certainly try it out.

That depends entirely on the "current" economic situation.

Your question wasn't posted completely.

also you'll need to figure out the "fomat" of your integer time column(s).

- are they expressed in seconds ?

- are they just numerical representations of...

how up to date are your statistics ?

(sp_updatestats / dbcc updateusage(0) with count_rows)

Your on SP2 without any cumulative updates. (current is sp3)

Do you see any other messages in your sqlserver errorlog file ?

I would try to start a trace and figure out...

you could opt to compress your .BAK files (zip or rar).

This way you would end up with about 25% of your backup file sizes.

With that volume (1TB) spread your...

Hopping in late ...

I've recently had about the same issue....

http://www.sqlservercentral.com/Forums/Topic678236-21-1.aspx

JohnG and Jacob helped out well.

Jacob Sebastian's article on XML are great.

What service pack are you on ?

Post the results of:

Select @@version

As always, it is acceptable if it serves you good.

I think MS Best practices states a number of 5 or 7.

Here are some nice guidelines on common stuff:

http://technet.microsoft.com/nl-be/library/cc966401(en-us).aspx

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,... !!