Is there any way I can change the object owner for over
100 tables in a single data base at once in SQL 7 without
using the sp on each table?

I am using the following to send mail, but instead of
@TO = N'yyy@abc.ab.ca'
I want to specify a variable from my procedure:
@TO = N@emailaddress

I've got a huge Reprot in Crystal 8.5.
I've discovered that I can't work with the report if I
change the Stored Proc the report is based on.  (this is
a kown and popular issue )

Do u know of a function that will return a field from the
previous record if the current record's field is null? I
know this is available in Monarch, but do not know how to
do it in SQL Server.

I've got a Join All stored proc which returns about
120,000 records.
It simpley returns Account number field and Balance field
for each acustomer ccount for each table.  

I have a column within a view that is a concatenation of several different columns of another table.  It goes something like:  tblA.columnA + '-' tblA.columnB + '-' tblA.columnC + '-' tblA.columnD As 'NewColumn'
Is it possible to define the size of the 'NewColumn' within the view? ...

I'm working on a report that gives a summary of data in a sql server
database.  The structure of the database is the following:
A company has one to many investments.  These investments are for a certain
sector, are of a certain nature and are in a certain state.  This gives us a

I'm in desperate need of some help. I am trying to
identify db objects that are no longer in use. i have a
list of sp's that are not being used, and i'm trying to
look in the body text of the sp (by querying the text

What would the equivalent syntax be to format the
following in SQL as can be done in Access.
Format("000000",employee) to return 012345 from 12345

I'm hoping someone can help me refine a trigger which will prevent writing records to a table (dbo.JOB) if the field value of Inserted.InvoiceNo already exists in dbo.JOB.InvoiceNo.
The syntax checks out on the trigger but I'm still able to write duplicate records into the table.  ...

I am trying to get dynamic SQL working with an IN list and
can't find any answers in the SQL Server Help.
1)I can get a simple parameter working as below
declare @sSql nvarchar(500)

Having a brain fart and I know this is simple but I've already wasted a
couple hours - so I was wondering if someone could help.
Example Source Table:
Id:        Company:        StatesCovered:

how do i create a view within a procedure that uses a variable defined in the procedur
regard
nikhil

Where can I get the hotfixe specified in the article?  It
looks like it should be a 'free' hotfix but the options
all cost $$$.  Please advise.  Thank you.  REF: Microsoft
Knoledge Base Article 830767.

H
I am trying to create a query or set of querys, which will allow me to retrieve the relationship data of a database.  In sql Server 2000 the user can create diagrams which show these relationships, what i want to be able to do is get this data, but i am having trouble finding a ...