Viewing 15 posts - 39,166 through 39,180 (of 39,605 total)
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
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
Viewing 15 posts - 39,166 through 39,180 (of 39,605 total)