Hi I have say table A and table B
Table A has the following data.
proj_num        contact_name      contact_phone
05-0001-00       Sam Eaton           111-1111

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
                             'Excel 8.0;Database=Z:\FILE\FILE.XLS;HDR=YES',
                             'SELECT * FROM [Country$]')
select  registrantid, firstname, lastname, title, company,address,

We have several versions of our database:
  OurDatabaseDev
  OurDatabaseQA
  OurDatabaseUAT

Is it possible to get metadata about columns returned by a strored procedure
in much the same way as you would from syscolumns?
the info im interested in is
Ordinal

I recently converted a Sql Server 2000 database to 2005 (using the copy
database method).  After conversion, all of the stored procedures executed
just as they had before . . . no problems.  I have run the following issue,
however . . .

Anybody know of a script that generate all of the jobs for SQL Agent?
TIA - Jeff.

For something that Microsoft, and the world, wants me to do, they sure make
it difficult to figure out how.
i want to use paramaterized queries with a command object against SQL
Server.

How do I take a datetime from an SQL table and convert it to the format
dd/mm/yyyy hh:mm?  I have tried this but it doesn't work :
convert(datetime, dbdate, 103)

My sites are using Classic ASP and got hit by the original SQL Injection
attacks awhile ago. I changed all my scripts that allowed members to
login to our website, to use Stored Procedures, instead of the normal
select statements that are easily hacked.

We do have a lot of DB's on our server. This is a copy of customer DB's with
Test data, but customized tables and prosedyres. We do take a standard
database backup of thes every day, but the data it self is of no importanse.
To reduse size we wonder if there is a way of automatic ...

Here you will find what I need
---------------------------------------------
Name        Region    No_Customers   No_Names
---------------------------------------------

How can i retirve information as follows :
1. User name who execute an sql statement.
2. machine name (on which machine sql statement execute).
3. is sql statement execute by directly by management studio/ qa or an

I have created a query to run in a .dtsx package.
I would like to parameterize it so that a user can input a value via the
Execute Utility dialog when the .dtsx package is double-clicked.
Any info would be appreciated!

Not very sure how to explain this. but perhaps with my illustration, you
guys will be able to understand.
Record stored in table
StaffID    Date / Time                     Status

I need to find out what relationships do NOT exist in a join table
-- employee table
create table #E (emp int)
insert into #E (emp) values (1)