Questions tagged [sp-help-operator]
6 questions
1
vote
1 answer
sybase - calling sp_help on temp table from a proc
I have several nested procedures. A temp table is being created in the 1st one and later used at several places. Currently I have created a index on the temp table, but need to verify as I am still seeing it to run for long time.
I tried to…
mtk
- 13,221
- 16
- 72
- 112
0
votes
0 answers
Export sp_help 'table' to file in SQL Server
I would like to know how I can export the result of sp_help 'table' to a .txt file.
When we run sp_help from a table, it returns various results that I would like to be saved to a file.
This is an example of what I want to save
EXEC sp_help…
Josue Barrios
- 440
- 5
- 10
0
votes
0 answers
What is FixedLenNullInSource in SQL Server?
I cannot find information what is FixedLenNullInSource in SQL Server?
Can anyone explain simply?
Prezes Łukasz
- 938
- 1
- 9
- 30
0
votes
1 answer
How to list column headers of a SQL Server table using sp_help perhaps?
I have a few tables with 70-80 columns in them. I would like to populate them with somewhat random data, unless I will not be able to do so due to key violation, etc.
The first step would be simply to get the list of all headers. There seem to be…
Hamish Grubijan
- 10,562
- 23
- 99
- 147
0
votes
1 answer
SQL sp_help_operator
Anyone know what group I need to belong to show up in the sp_help_operator list?
madcolor
- 8,105
- 11
- 51
- 74
0
votes
1 answer
SQL Server sp_help : how to limit the number of output windows
Normally successful execution of
sp_help [object_name]
in SQL Server returns a total of 7 output windows with various results out of which normally I am interested in only 2 windows namely the one with all the column information and the one with the…
slacker
- 157
- 1
- 3
- 13