Viewing 15 posts - 37,576 through 37,590 (of 39,757 total)
Totally agree on the SQL Logins. What about locking the account after 3 failed attempts!!!
Feel free to submit these to sqlwish@microsoft.com. It goes to the dev team.
Steve Jones
June 25, 2002 at 3:20 pm
It sounds like a security issue. Is the server running as local system? Or a lcoal account? Is it a local administrator.
Is this truly local or a virtual drive for...
June 25, 2002 at 3:18 pm
That will do it. In 7 you have this option, in 2000, this is "simple" mode.
Steve Jones
June 25, 2002 at 3:16 pm
You are welcome and looking forward to seeing you back here. Pls tell your friends and coworkers who use SQL Server
Steve Jones
June 25, 2002 at 3:14 pm
Haven't used them mainly because I haven't had any transactions that I use that fit.
If I did a specific update and was concerned about rolling back to that point, I...
June 25, 2002 at 3:12 pm
You could union these if you did not need the sums on the same row. If you do, then I would use each of these as a sub-select. that's the...
June 25, 2002 at 3:10 pm
Check the settings for the database. Is it in simple mode? Are non-logged operations being performed?
Steve Jones
June 25, 2002 at 2:37 pm
why use local variables? I do the same thing often, but it's something like:
UPDATE SSnumpin
SET PIN = b.PIN,
FirstTimeFlag = b.FirstTimeFlag,
CallCounter = b.CallCounter,
Lastname = b.LastName,
FirstName_MiddleInitial = b.FirstName_MiddleInitial,
EmpNum = b.EmpNum,
PINChangeFlag = b.PINChangeFlag
...
June 25, 2002 at 2:35 pm
Can you post some DDL to be sure we get this right?
I think you want a single result set, correct?
select sum(a.strCost)
sum( b.strAmount)
from tblItems a
inner join...
June 25, 2002 at 2:33 pm
You can use osql, just PRINT or SELECT your variable whenever you need output.
Steve Jones
June 25, 2002 at 2:30 pm
Dan has good suggestions. Another option is to enhance your app to lock the account after 3 tries. Can be painful, but most password systems (outside of SQL) do this...
June 25, 2002 at 2:28 pm
IF you have a duplicate PK, this will fail, regardless.
You can update the PK of a table as long as it does not conflict.
Can you post all the code?
Steve Jones
June 25, 2002 at 12:55 pm
Double check you restored the right log. Do it in EM and then "view contents"
This is usually what Andy posted, a gap.
Also, do you append or overwrite when you do...
June 25, 2002 at 9:49 am
Where are you backing up to? Local or remote drive?
Also can you manually run a backup in Query Analyzer?
Steve Jones
June 25, 2002 at 9:44 am
I'd post some more information under the DTS forum and we'll try to help. Or under the replication section.
Steve Jones
June 25, 2002 at 9:35 am
Viewing 15 posts - 37,576 through 37,590 (of 39,757 total)