When I execute sp_help I get all objects in a db.  Is there a way to get
a listing of only the table names?

I have a stored procedure which is as follows:
CREATE procedure prr_temp_source_partnum_out
@part_num1 varchar(20)
@part_num varchar(20) output

I have the following procedure where I am getting an output parameter value
as follows. Now I would like to use this output parameter value to use as a
input parameter of a different procedure.
FIRST procedure and its call

I have a VIEW like this:
Table1:
col1 varchar(8),
col2 varchar(8)   // col2 is an unseparated date string 'yyyyMMdd'

So I'm creating a database to store locations, and the links between them.
The plan is to use the data to manage travel and route-finding in a
fictional world. The basic tables are as follows (there is more to the
tables, but this covers the basics):-

I am trying to get the value of an output parameter by running a stored
procedure. This output paramter should give back a result value. However when
I am running the sp from qa I am not seeing any result. Instead command
completed successfully message is coming. I would ...

From what I've read, if a spreadsheet has column headers, you can
update data in the spreadsheet from SQL.
If I insert the data from the linked server, I can upate that data...
but if I open the file, add data, save it and close it, .. the new rows

I need to be able to insert around 400 million rows into a sql server
database everyhour. The bulk insert is going to one table which has no
indexes and the database is set to bulk logged. I have set auto create
statistics off and have messed around with the batch number. The best I ...

I'm new to SQL server programming. Want to know more about error handling.
To handle error i'm using following try/catch
begin try
....

I am trying to do this query, in which I get a list of all users on my
site, the number of aircraft they have, and then the number of flights
they have logged.
So, I'm trying this:

I'm doing a backup through the SMO components in .NET.
It works fine except that I can't validate if the folder on my SQL Server
machine actually exists.
Is there a way to do a validation through SQL server management objects plus

Can someone show me the sql script to get the last job run duration from the
sysjobshistory table per job name from sysjobs.
Output I'm looking for:
Jobname LastJobRunDuration

Hi Guys I have the following VBS script, I get Could not find Stored
Procedure on the Execute line below.
When I examine the strSQLQuery data it contains "select * from people where
userid = 'js36'"  (with quotes).  It falls over too if I run it in QA with

I'm trying to implement error handling in my sp which writes to a user
defined nt event log.  I've tried RAISERROR , but it writes it to the
"Application" log as well as xp_logevent.
They almost need a "log name" (e.g. /L) switch to choose the log to

I always thought Sql