Viewing 15 posts - 39,031 through 39,045 (of 39,466 total)
Change to a real table. Make the same structure, but include a column for SPID.
At the beginning, detele from mytabel where Spid = @myspid
then insert your values with the current...
November 7, 2001 at 10:23 am
I agree with the SP_OAxxx procs instead of an extended stored proc. MS says only C, but be wary of registering extended stored procedures. This is a great way to...
November 7, 2001 at 10:19 am
Bruce,
192.168.x.x addresses are private addresses. As such, they are non-routable across the Internet.
What usually happens is the router or firewall performs a process called NAT (or PAT) which translates the...
November 7, 2001 at 10:16 am
November 7, 2001 at 10:09 am
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
Viewing 15 posts - 39,031 through 39,045 (of 39,466 total)