Viewing 15 posts - 36,901 through 36,915 (of 39,720 total)
no.
change is made by user.
change recorded in log file (in memory).
change recorded in data file in memory
change recorded to log file on disk. May be checkpoint, may occur if system...
October 29, 2002 at 9:26 pm
You make a change. This is written to memory (buffer). On checkpoint, if it has not been written to disk, it now is. The normal, write log, write disk 2nd...
October 29, 2002 at 2:32 pm
You have an OS link. Go into Control Panel|Server or My Computers|Manage, depending on OS and look for open files. This should give you the login.
Steve Jones
October 29, 2002 at 10:16 am
Isn't this login or security error?
Perhaps you are expecting something to be created or loaded that happens when the rest of the steps run?
Steve Jones
October 29, 2002 at 10:14 am
I'd use a different join
from DataNortel dn
inner join DataLucent dl
on dl.ecp = 2
and dl.sid=4376
...
October 29, 2002 at 10:12 am
Or chr(13). I use Allen's suggestion. If you need the normal DOS end of line, use mine.
Steve Jones
October 29, 2002 at 10:08 am
I've got Erwin and the same thing occurs. IMHO, Erwin 4.0 isn't a great product, especially for a 4.0 product. No NT Auth, cumbersome design.
I tend to do things in...
October 29, 2002 at 9:04 am
You can have the traces start be setting a startup procedure and starting them in that procedure.
As far as loading into a table, not sure. Have to check. Whether you...
October 29, 2002 at 8:50 am
Which Service Pack? My SQL 2000 SP2 server (one I tested) works.
Steve Jones
October 29, 2002 at 8:43 am
Should work fine if you get the drivers. DTS doesn't require SQL Server to run and this is a great application for it. I've used it to move between Access...
October 28, 2002 at 1:15 pm
Heard good things about Marathon. Kind of $$ for most people, IMHO.
Interested to hear how it's working for you.
Steve Jones
October 28, 2002 at 1:10 pm
Winners in today's newsletter.
User Name Points
Antares686 578
chrhedga 364
rmarda 331
Steve Jones
October 28, 2002 at 10:46 am
sp_helprotect will get you most of what you want, but it will be kludgy and I think you will need to run it for someone in the role.
Steve Jones
October 28, 2002 at 10:44 am
Not sure about the VB stuff, but I believe Decimal and numeric are the largest types. Go to 38 bytes. the float and real are 8 bytes using a matissa...
October 28, 2002 at 10:20 am
Viewing 15 posts - 36,901 through 36,915 (of 39,720 total)