Viewing 15 posts - 286 through 300 (of 327 total)
I looked there and didn't find it. Don't see SQL Server Project either.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
January 6, 2006 at 3:26 pm
OK - I've got it now but unfortunately, I haven't got an answer for it.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
January 4, 2006 at 8:51 am
I may not be understanding the scenario correctly. It looked like Track2 is basically a standby for Track1. I beleive you can do Transactional Repl to it and that should...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
January 4, 2006 at 8:12 am
Make Track1 a re-publisher and Track2 its' subscriber.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
January 4, 2006 at 7:01 am
It sounds like the distribution agent is scheduled and you may need to shorten the period between runs or change to continuous distribution. Continuous distribution would provide the least latency...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
January 4, 2006 at 6:55 am
No - EM in 2K used replaceable parameters. [SRV] would be replaced by the server name currently selected in the list of SQL Servers. I was hoping to di the...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 28, 2005 at 1:32 pm
How are you entering the arguments. All I seem to be to see is my own C drive.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 28, 2005 at 12:26 pm
try looking here: http://www.sqlis.com
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 28, 2005 at 6:59 am
Another thought - why not set the variable @body = <query>?
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 21, 2005 at 7:39 am
I don't know much about OA but there is a script about SMTP mail here: http://www.sqlservercentral.com/scripts/contributions/510.asp
Maybe there is something in it that will help.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 21, 2005 at 7:20 am
I really don't know. I've not replicated views, I just know that they can be replicated. I would venture a guess at the data winding up in the base tables but...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 20, 2005 at 2:41 pm
Views can be replicated so why not create a view witht the parent/child rows in it.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 20, 2005 at 1:29 pm
See this link:
http://www.sqldts.com/default.aspx?304,1
it shows how to use the FSO to find files in a folder and pass the names to a package.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 19, 2005 at 6:52 am
thanks for the response but from what I see, the documentation seems to apply only to the initial installation of SQL Server.
I did a manual installation on a server and...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 14, 2005 at 2:26 pm
Thanks - I did find that SQL 2000 supports it in a non-clustered environment (which I wasn't aware of) and 2005 adds clusters.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 13, 2005 at 6:25 am
Viewing 15 posts - 286 through 300 (of 327 total)