Viewing 15 posts - 121 through 135 (of 135 total)
More info: After relinking, I found that all Win2K machines worked fine, but most Win98 ones didn't (only one did). This, in conjunction with a new search on the...
February 4, 2003 at 11:22 am
quote:
When MSAccess links tables with ODBC DSN, some info is extracted from the DSN and stored in the 'table'(link) properties. If...
January 30, 2003 at 9:50 am
As long as we're talking about comments, here's my #1 rule: The most important word in a comment is "because" (or appropriate synonyms, of course). It's even more...
January 29, 2003 at 2:35 pm
We import fixed-field files every day (from an AS-400 running, I presume, COBOL) to our 7.0 database. The trick is to tell the format file that the LAST delimiter...
January 9, 2003 at 3:03 pm
Well, now I see what happens when the system is slow and I hit Submit twice. Oops!
quote:
To stop SELECT INTO from...
January 7, 2003 at 1:22 pm
quote:
Why not to make an alter table alter column ColumnName NOT NULL after the insert into statement.So you can create your primary...
January 7, 2003 at 12:27 pm
quote:
Why not to make an alter table alter column ColumnName NOT NULL after the insert into statement.So you can create your primary...
January 7, 2003 at 12:27 pm
quote:
SELECT INTO doesn't generate tlogs like an INSERT statement does.
I've found this to be true,...
January 6, 2003 at 3:56 pm
Yeah, back when I found out about UDT's I was all hot to use them, until I wasted a lot of time searching through the docs for how to CHANGE...
December 16, 2002 at 2:58 pm
Well, Paul, I'm rather tickled that someone else besides has also hit upon the idea of using sp__ to identify locally-written system stored procedures.
I think I understand the performance issue...
November 25, 2002 at 10:03 am
quote:
I would probably still use the whole object name regardless though. This way I would be sure that I was calling...
November 13, 2002 at 2:58 pm
quote:
What you could do is build a database specifically to house stored-procedures, and any other objects that are commonly called across your...
November 13, 2002 at 2:12 pm
I have 150+ DBs, and want certain procs to be used from anywhere. The only way I've found to do this is to put them in master and prefix...
November 13, 2002 at 10:26 am
I have a library database that I create all my systemwide stored procedures in. Since I haven't found a way to run the procedures directly from there (without the...
October 7, 2002 at 10:01 am
Viewing 15 posts - 121 through 135 (of 135 total)