If you can't pass something to the callee you're screwed. You'll have to change the code in all the calling procs to accomplish this. And the simplest way...

Sybase to sql server .

Raiserror ('message here', SeverityLevel, ??)

look it up in the books online for the exact details.

Can't tell you untill you show us SAMPLE DATA, SAMPLE RESULTS.

I'm still wondering why he's using ntext instead of nvarchar... I know my users and they don't like to type 3-4 pages of paragraphs just for the fun of it.

Can't wait to see that day .

The server use cached data too. If you simply delete the tablename, the data may remain in ram and god knows in how many global variables to the server/em/qa....

I have to assume sometimes... now and then I feel like I'm interrogating a POW to find out the info I really need to solve a problem

Whatever = update whatever you need to.

Unique values for pk and fk?? They have to be MATCHING VALUES.

Can you show us the before and after picture of what you...

CREATE PROCEDURE dbo.SPName @DateStart as datetime, @DateEnd as datetime

AS

SET NOCOUNT ON

Select WhatEver from dbo.YourTable where DateCol >= @DateStart and DateCol < @DateEnd

SET NOCOUNT OFF

This kind of sp allows you to...

If the server is trying to select from a missing table that he thinks should be there >> that might cause some problems.

Sure is... I'm glad you're not solely basing your choice on that... I may take that interview now .

Got other threads to answer and some reports to build... got my days of worked planned already so I can live without this problem

I was assuming an id list. Another way would be a #temp table where you'd insert the data to and use that table to do the rest of the...

HTH.

I see. Might I suggest a simple security add on.

Add this verification before using the variable as the tablename :

IF EXISTS (Select * from DBNAME.dbo.SysObjects where name =...