Viewing 15 posts - 1,321 through 1,335 (of 6,216 total)
Good comments and good answers. Yes, it is open ended. The point Im trying to make is that answering the question is not simple by any means. Instead of triggers,...
November 26, 2003 at 7:58 am
Not much difference between VBS and ASP. As far as using output parameters, it works the same as plain ADO from VB...except!
- You have to declare the constants in code...
November 26, 2003 at 7:52 am
Back to the main topic, I'd say as much reading and interaction as you can manage. We all tend to be limited by our environment, nice to talk to people...
November 26, 2003 at 7:47 am
Number one didnt look that bad to me. A minor variation would be to link the SQL tables in after you create/update/verify, then just do a straight append. Probably not...
November 26, 2003 at 7:43 am
Exactly. I'd suggest doing one thing at a time. Either move to NT authentication or upgrade to AD, dont do both at once.
That said - I see nothing wrong with...
November 21, 2003 at 11:53 am
No easy way if you'd have same pkeys in both db's. You'd have to change them in one or the other - or add an additional column to make it...
November 21, 2003 at 11:24 am
Sysdepends ends up not being very reliable. Plus, it has no concept of cross db dependencies, so you end up keeping track manually anyway.
Andy
November 21, 2003 at 11:20 am
Thats interesting. So you're going to go against system tables directly? What about for Yukon? I've used DMO with decent success, but definitely not for anything that had to be...
November 21, 2003 at 11:19 am
I think its always a good idea to have your DBA involved. Why wait until the end?
Andy
November 21, 2003 at 7:18 am
November 20, 2003 at 8:33 am
Havent seen that before. Tried backing up and starting from scratch? You're doing plain transactional, no queued or immediate updates?
Andy
November 20, 2003 at 8:32 am
As far as I know only columns and indexes get replicated. Never paid attention in SQL7. You can always add them with a post snapshot script.
Andy
November 20, 2003 at 8:30 am
Only needed if you're attaching to a different server and only if you have SQL logins (unless its a different domain). If you're going to do this a lot it's...
November 20, 2003 at 5:46 am
I'd say it depends. Mostly we are using one table, but in some cases there is additional data that is associated with the lookup value we usually create separate tables...
November 20, 2003 at 5:41 am
Need to narrow it down. Look for the proc that has the highest CPU utilization, then see if it makes sense and what you can do to reduce it.
Andy
November 20, 2003 at 5:35 am
Viewing 15 posts - 1,321 through 1,335 (of 6,216 total)