Let me add a link to Pinal Dave for Database Publishing Wizard. If you scroll down, you will see some comments on 2008 and that this installs with 2008.

http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/

Thanks,

Jared

Roust_m (10/18/2011)

---

jared-709193 (10/18/2011)

---

Easy enough! 🙂 Use the wizard to script what you want, or script the entire database and then remove what you don't need. You may want to add...

Are you sure it went into the primary filegroup? Why is primary filegroup even a part of your partition schema? i.e. I have 12 filegroups other than primary, 1 for...

I understand that the database is 2GB, but not the data for the month right? That is only the size of the data that has been entered since. My...

🙂

"<table_source> can be a remote table or a derived table that accesses remote tables."

Why not create the procedure on the target? Would run much better too...

Thanks,

Jared

SQL Kiwi (10/18/2011)

---

jared-709193 (10/18/2011)

---

A question that I have is... Is there a performance reason to use or not use a TVF (by this I mean one that uses CREATE FUNCTION...

Right-click on the linked server and go to properties. Then go to the security section and click on the ADD button.

Thanks,

Jared

I can't find any documentation about MERGE not working on linked server... However, if it is not working from the source side I would try running it on the destination...

The job that I took in April of this year was one of these types of interviews....

jared-709193 (10/18/2011)

---

EDIT: Maybe discussing the question on replication is important. My thoughts are that it is not performance that is the deciding factor on which type of replication to...

Great article (although I am a little late getting to read it)!

A question that I have is... Is there a performance reason to use or not use a TVF...

Thanks Gail! Exactly what I was looking for!

Jared

In my limited knowledge of the comparison between correlated subqueries, inner joins, and CROSS APPLY... It looks like all 3 queries below produce the same execution plan. Why would...

EDIT: Maybe discussing the question on replication is important. My thoughts are that it is not performance that is the deciding factor on which type of replication to use,...