Hello all!
Can one dev help another? Is there any way to get the column schema from a
stored procedure without calling it with parameters in slq server 2000? I
just want to know the columns it returns.
Many thanks,
Sincerely,
Patrick
...
more >>
Basically I need an If statement in a query. I am working on website for my
Wife (She is a teacher) and she will be posting spelling words to this
particular page. She wants the parents to be able to either see all words or
only the words for a particular week.
I have modified the club sit...
more >>
sp_provider_types_rowset and some other stored procedures keep being
executed
We recently experienced a very interesting problem. When connecting to SQL
Server 2000 (SP4) using ADO, after the recordset is retrieved, we can see
the following stored procedures kept being executed every we su...
more >>
I'm writing a database maintenance asp.net utility that generates sql....
I have a function that adjusts the column names to a valid name to be used
in a select statement. For instance one of the things it does is convert
"DataBase Name" to "[DataBase Name].
I was testing it with the Adve...
more >>
I'm stumped by what seems like a simple problem:
How do I query a SS2k named instance on the same machine?
Here's my scenario -
Machine name Alpha has SS2k installed as the default instance, plus it has
SS2k
installed as named instance Beta. Both instances have a database named
'Clients'...
more >>