Viewing 15 posts - 36,616 through 36,630 (of 39,717 total)
Oh, how I agree. That is annoying. I wish I could get the scripting engine to format differently as well. Don't have a solution other than a custom scripting tool....
January 6, 2003 at 10:17 pm
you are welcome.
it worked as I wrote becuase your WHERE clause was filtering out the tblrequired value.
Steve Jones
January 6, 2003 at 5:01 pm
The issue is your WHERE clause.
If I run a left outer join like this:
SELECT
StepID,PrequalID, RequiredPageDescription, RequiredPageURL , SectionNumber, StepNumber
FROM dbo.tblRequired
left outer JOIN dbo.tblStepStatus...
January 6, 2003 at 3:52 pm
Kind of off topic, but yes, you do want to do the joins in the join clause. I was shooting for a simple example, but in reality I'd probably have...
January 6, 2003 at 3:41 pm
Can you post some DDL? Not sure hwat you mean. Also perhaps a sample data set.
Steve Jones
January 6, 2003 at 2:07 pm
Can you post some DDL for the tables? I suspect what you want is a left outer join, but I'd need some code to be sure.
Steve Jones
January 6, 2003 at 1:24 pm
January 6, 2003 at 12:35 pm
Not sure of the issue. Could be your NIC requires the CPU (some do, some don't).
What's the replication scenario? Transaction? Merge? Push/pull?
Steve Jones
January 6, 2003 at 12:14 pm
We are thinking of doing this annually. Love to let you choose the articles, but the cost would be too high, well above $15.
Initially, this will be a US only...
January 6, 2003 at 11:37 am
January 6, 2003 at 10:00 am
I'd stick with one data file. Simpler is usually better.
As far as Netware, no chance. If anything, I'd like to see SQL Server on Linux, but after talking with developers...
January 6, 2003 at 9:53 am
No, best advice is to script things and run it against both databases. Similar to what I did here:
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
Steve Jones
January 6, 2003 at 9:48 am
Thanks for the commments and glad to see there is interest.
We hadn't planned on a CD due to cost, but we can work on that. Most likely we'll have downloads...
January 6, 2003 at 9:43 am
Lots of questions. On the simple recovery ?, it limits the restore ability. You can only restore up to the last full or full + diff backup. Not recommended...
January 5, 2003 at 11:39 am
Shouldn't be that much different, but keep in mind you want to pre-allocate the sql space, so you might make it larger for that reason.
Steve Jones
January 3, 2003 at 12:40 pm
Viewing 15 posts - 36,616 through 36,630 (of 39,717 total)