Viewing 15 posts - 39,286 through 39,300 (of 39,717 total)
Haven't seen this. I will pass along to some others that have done more upgrades.
Steve Jones
November 7, 2001 at 9:58 am
David is right. You have some type of access. Every user who is connected to a database obtains a shared database lock to prevent detaches, restores,e tc.
Steve Jones
November 6, 2001 at 3:04 pm
My final two cents as advice.
The two toughest interviews I had:
1. I was taking the place of a consultant. He sat me in a room with the VP of IT,...
November 6, 2001 at 3:01 pm
I used to use the maintenance plans for backups, but my issue is when there is an issue, I don't get good reporting.
Things you should worry about:
Backups
Integrity checks (dbccs) weekly
Business...
November 6, 2001 at 2:30 pm
Where there's one, there will often be more. What's wrong with having a Eng1 group and adjusting the rights there? If they leave, you are no worse off. If they...
November 6, 2001 at 11:10 am
brian,
perhaps PASS would create an after hours forum at the conference on this? Maybe a poll?
Steve Jones
November 6, 2001 at 11:08 am
That sounds like the best solution. You could always use an ActiveX conversion to cast the data into a decimal format, but it would probably be slower.
Steve Jones
November 6, 2001 at 11:05 am
November 6, 2001 at 10:56 am
The default for SQL Server is only potr 1433 (TCP). Enterprise manager is another story, it uses 445 (I think).
If your ASP page needs access, then whoever controls the...
November 6, 2001 at 10:55 am
Strange. The isql/w call is the same as the ADO call?
Can you script an ASP page and enter the exact same call in both the page and isql/w and see...
November 6, 2001 at 10:50 am
Glad we could help. Rather than full-blown SQL Server, if this is a small app, use MSDE. Basically SQL Server light and do not provide any of the client tools....
November 6, 2001 at 10:34 am
November 6, 2001 at 10:14 am
Same here. No problems, but not used extensively. Mainly because of the $$ involved.
There are some reports of problems in these forums. Searched on "named instances"
Steve Jones
November 6, 2001 at 10:12 am
November 5, 2001 at 10:56 pm
Don't connect in global.asa. Put the connection string there and then reference that on each page as Jon suggested.
Steve Jones
November 5, 2001 at 10:54 pm
Viewing 15 posts - 39,286 through 39,300 (of 39,717 total)