It would be better to have

os - 2 disks raid1

logs - 2 disks raid1

data - 2 disks raid1

This is an optimal hardware design to begin with. You may...

Good question .. I would hope that this is a feature the sql developers got in at the last minute, unfinished. Hopefully this backup behavior will be corrected...

Why not put the xml text into an xml data type field in another table? From there you should be able to use the many new xml tools in sql...

After rereading the question, I see what it is really asking...My question is, why would you want to reference a synonym on a linked server?

I can see, if...

My research led me to this article http://www.sqlmag.com/Article/ArticleID/50381/sql_server_50381.html

which states that you can indeed use a synonym to reference a linked server as if it were local:

You can use...

using the wizard?

No cheating here...this is learning. Thanks for the questions sqlservercentral. This is a great resource to get sharp with.....!

😀

Are you working on an existing report or creating new?

A good thing to do is use the report creation wizard to create a couple of sample reports to...

I see what you are trying to do with the script....I little more background info would be great though....set the stage...;)

Unfortunately you can't ignore the logs unless, that is, you are using simple recovery model (not recommended). Assuming logging is going on, I would start with logs on one...

use your text book and skat...

Unfortunately (for you) or fortunately (for me) no problems encountered with current service pack.....leave it alone...

Thanks:cool:

file is removed after success

http://www.sql-server-performance.com/article_print.aspx?id=1203&type=art

I'd go ahead and put in a request for another raid drive. You've got things split up pretty nicely now and this future plan looks good under these constraints....

you should be able to pass a parameter on the command line using dtsrun utility and the \A switch.

Within the vb/activex code you reference the global variable like...