Viewing 15 posts - 1,171 through 1,185 (of 1,185 total)
Thanks for the heads up! Thought I was doing something wrong!
Oh well. Your suggestion is how I set-up my "work-around"
AJ Ahrens
SQL DBA
Custom Billing AT&T...
January 7, 2003 at 12:28 pm
I have just gone through this myself. I created a new server with windows 2K/SQL 2K. I set-up my SQL 7.0 box as a linked server. I...
December 19, 2002 at 6:26 am
I use a similar process for detection of a .DONE file. I have built a VB6 exe and fire a DTS package every 2 hours from 7:30 am >...
November 25, 2002 at 7:03 am
I have had a similiar issue with a stored-proc. The procedure ran in under 10 seconds and it ran fine for over 18 months. 1 day it stopped...
November 25, 2002 at 6:03 am
acudlip,
My last company went through the following:
SQL 6.5 dual processor > SQL 7 quad processor with replicated machine for reporting >
SQL 7 quad processor replicated machine across 3 different...
November 21, 2002 at 5:52 am
Why do you use #Temp tables. YOu may also get a performance boost by creating a table and having the data load into that. Then you could apply...
November 21, 2002 at 5:24 am
i have to agree with both mcap and scorp. THe jobs I have been happiest with and currently am at:
Hired on personality, eagerness, and the ability to see the...
November 20, 2002 at 5:52 am
Just throwing my 2 cents in.
I have been in the IT world for 13 years. I have used SQL Server for over 4 years starting as a developer, junior...
November 18, 2002 at 6:05 am
Haven't been able to do that myself either.
I would probably still use the whole object name regardless though. This way I would be sure that I was calling the...
November 13, 2002 at 2:21 pm
quote:
Is there any OTHER way to have SQL search a common "library" to find the proc? (I have 7.0 now, and...
November 13, 2002 at 10:35 am
I 100% agree with the NEVER use sp_ as the first 3 characters. I use the spA, spD, spU etc... I was lucky enough to not fall into...
November 12, 2002 at 8:40 am
quote:
I think we would be interested to see how you do it !John
John,
please...
November 12, 2002 at 7:51 am
I use spA_ append, spD_ delete, spU_ update. I have required that submittal forms be sent in when changes are made or objects created.
Also at the top of every...
November 12, 2002 at 6:20 am
I am currently doing this same thing in SQL 7 and SQL 2K. Please read whole article.
Our older process uses DTS and BCP to load data and process...
November 12, 2002 at 6:13 am
I used to use Access (still do for simple manual tracking).
I have ran into this problem in large and small shops. I have found the following to be the...
November 4, 2002 at 6:09 am
Viewing 15 posts - 1,171 through 1,185 (of 1,185 total)