if exists(select * from dbo.sysobjects where id =
object_id(N'BBSItems')
and OBJECTPROPERTY(id,N'IsUserTable')=1)
drop table BBSItems

Does anyone know how to select the last time a stored procedure was compile
and which recompile condition caused it?
Thanks,
E

The part of my stored procedure giving me problems is this:
***********************************************************************************************************************************
 ---------------------------------
     -- FINAL OUTPUT - Two Record Sets

Using SQL Server 2005 Dev and SQL Server Manager, how do I dump a table and
it's data to a file then import it into another table?
I see the options "Script Table as" and then the Create To, Drop To, etc.
options, but all of those only put the structure in the file. What am I

In my DTS I am updating an Ingres database on a different server.
I'm getting the following error immedtiately ....
HResult of 0x80040e09 (-2147217911) returned
Unexpected error occured. An error was returned without an error message

Total SQL newbie here. Hope I'm posting in the correct group.
I have a Exchange 2003 server that archives all email to a large(55GB)
SQL database. I have a situation where I have to export several emails
from that database. However at this point I am clueless on how to

Shoud a SQL 2005 database remain open in a Visual Basic program, or should
it be opened and closed in every subroutine?
Thanks for any info.

Is it a good idea to have multiple contains? I have this query:
Select * from myTable where contains (Col1, 'Africa') or (Col2, 'Africa')
Also, I tried this, didn't return anything:
Select * from myTable where contains (Col1, 'Africa*') or (Col2, 'Africa')

Could someone help me, I'm getting this error message:
Procedure or function UpdateResources has too many arguments
specified.
Here's my stored procedure, I am trying to update four columns, two

I'm trying to link two tables... one for Employees and the other for
Timecards
I need to get a list of employees that do not have timecards on an
SPECIFIC DATE

Whats the 'normal' maximum count of tables in a join and what if there are
views involved.
What about nesting views

I am trying to Pass Column Name(FieldName) using Parameter in SQL
Statement... But i am getting error...
how can i pass Column name using parameter???
Example:

How can I concatenate specific fields across records in a query?
Here is the layout of my table:
CREATE TABLE [rdb].[image_use](
[RecordID] [int] IDENTITY(1,1) NOT NULL,

I run the following query on a database (SQL 2005):
delete from person where pers_companyid in (select pers_companyid from
company where comp_expiry is not null)
I wanted to delete all people associated with a company which had an

I am getting the following intermittant error upon accessing data
from
my server:
Run Time Error '3146' ODBC Failed  [Microsoft][ODBC SQL Server