I am using a DOS Batch File (within DTS) which calls FTP to logon to an FTP Site and downloads files. The Batch File works find but I want to be able to check the FTP Connection to make sure it was established. Is there an FTP Command that can be used to check to […]
2004-02-24
11 reads
Randy says that the biggest reason we have so many injection vulnerabilities is that all the asp books use inline sql for their examples! We STILL encounter developers who don't understand injection. Read and pass on to your dev team.
2004-02-24
15,530 reads
Since last week Friday all our sql2000 mmc crash when we use the register server wizard and have it browsing for servers.AppName: mmc.exe AppVer: 5.1.2600.0 ModName: semsfc.dll ModVer: 2000.80.760.0 Offset: 00020429My windows-admins are searching if it might be related to some security-hotfixes they've instaled,bot they don't have a clue yet.Anyone over here experiencing the same […]
2004-02-23
4 reads
Thanks Frank, it a good site well I emailed him fingers crossed and the book is out of warranty thats why couldn't get a replacement Mikey
2004-02-23
The statement you provided only updates 1000 rows out of my table.I am new at SQL so I am not sure if I need to include anything else. I do appreciate your help.-Mike
2004-02-22
Sorry that I did not make myself clear. What I would like to be able to see, is the descriptions for all of the tables when the Table folder is open, i.e, instead of, or in addition to, the Owner, Type and Create Date columns, add the Description column
2004-02-20
IMO Enterprise Manager would be to tedious to manage that many servers. It could be used to investigate problems, but for overall monitoring I wouldn't rely on just that. There are a few options. I believe one is a tool called SQL Monitor. I do not have the financial support to buy a tool so I […]
2004-02-20
Try thisselect 'sp_addlogin ''' + a.name + ''',@sid=',a.sid,',@passwd=', CONVERT (VARBINARY (32), a.password),',@encryptopt=''skip_encryption''' + char(13) + 'GO' FROM syslogins AS a INNER JOIN maxprod.dbo.sysusers AS p ON a.name = p.name where a.name = 'RUSSELLVILLE' Which will convert the password to varbinary plus will also set the sid. This works OK for me on SQL7.
2004-02-17
This is a pretty generic message and hard to troubleshoot without more information. When I've seen it in our place it was with a Sybase app and it's always been client installation or configuration issues. For whatever reason, the client can't talk to the DB which can mean anything from a missing dll to to the […]
2004-02-17
1 reads
I created several jobs on a SQL Server 2000 machine running Win 2003 server. This server was later renamed in the domain. Now all of the jobs that were created prior to the name change can not be edited. I always receive the following error message when I attempt to edit or delete the job. […]
2004-02-16
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers