Viewing 15 posts - 39,016 through 39,030 (of 39,456 total)
VB is fine, but then you can't bring it back to the designer. This is fine if your people know VB.
Steve Jones
November 7, 2001 at 11:14 am
Interesting. Never had anyone yell at me like that, but I'm 6', 200, so that may be part of it.
I got offered both jobs, took the first at the time....
November 7, 2001 at 11:13 am
If you add the second address to the NIC in NT, then you need to reboot the box and SQL should listen on all NICs/addresses.
I have multi=homed boxes and this...
November 7, 2001 at 11:09 am
I have a "trim BAckup files" script on this site the you may be able to adapt. You would need to add a connector to the SQL Server to get...
November 7, 2001 at 11:04 am
Don't have any v7 servers here. Try running profiler with the sa logon and see what happens.
Steve Jones
November 7, 2001 at 11:02 am
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
Viewing 15 posts - 39,016 through 39,030 (of 39,456 total)