Viewing 15 posts - 2,401 through 2,415 (of 6,216 total)
I'd like to say, but we'll have to go with maybe! We've put off forum changes for a while (everything working smoothly) but we do need to make some changes....
March 11, 2003 at 5:07 am
If you want to really, truly add two recordsets together, there are a couple ways. First would be to loop through one recordset and add each to the second. Another...
March 11, 2003 at 5:05 am
Have you changed your indexes? Data order is only guaranteed if an index is used (including clustered of course). Could be a result of a service pack too.
Andy
March 10, 2003 at 6:05 pm
Might start at http://www.fawcette.com (home of Visual Studio Magazine), http://www.msdn.microsoft.com, http://www.codehound.com. Data access to Access should be straightforward, look into using the standard data namespace, not the SQL provider.
Andy
March 10, 2003 at 5:01 pm
We're just about to put an EMC SAN into production, everything looks good so far. Using Win2K AS, SQL2KEE.
Andy
March 10, 2003 at 4:59 pm
Two as in you've implemented transactional with immediatley updating subscribers, or true bi-directional where each subscribes to the other?
Andy
March 10, 2003 at 1:27 pm
March 10, 2003 at 1:24 pm
Only if you're going to cluster or use more than 4g of memory.
Andy
March 10, 2003 at 1:23 pm
Look at syslogins in BOL. It's a view, so you can see how it decodes sysxlogins.
To trap the login, you'd have to run a profiler session I think, or force...
March 10, 2003 at 9:58 am
It should work fine. There is a difference between SAN and NAS, I think NAS is the one with the caveats. I think you should put all your data on...
March 10, 2003 at 9:55 am
Had a similar post recently, same product?
Andy
March 10, 2003 at 8:11 am
Right now I just obscure them, but they are in the executable. Working on a solution that stores them serverside and encrypted, app pulls what it needs and decrypts. Not...
March 10, 2003 at 6:18 am
Well, to be honest - I queried sysxlogins, found a login that was junk, ran sp_password, looked to see what if anything changed. Can't guarantee that is the only way...
March 10, 2003 at 6:16 am
You'd have to query on xdate2 in sysxlogins, then just reset the password to a random value. Don't think you'd need a trigger, just a simple job. Throw in some...
March 8, 2003 at 5:06 pm
I'm able to make changes to my test machine that has allow updates set to 1.
Andy
March 8, 2003 at 8:18 am
Viewing 15 posts - 2,401 through 2,415 (of 6,216 total)