I might want to prepare a report for management detailing the state of the database and recommended actions. I would be careful here not to be judgemental, just the facts....

Thanks all. I went with dwain.c's "normal" catch all query form.

>>Additional questions. What results should be for this?

The parameters will be validated through an user interface so I don't expect any of those conditions to exist.

This works as expected. I can set the ssrs dataset query properties by declaring the table valued parameter, populating it with previously set ssrs parameters if needed, and then passing...

Thank you mister.magoo

Below is working code....

I'll follow back up when/if i can get this working in my ssrs report.

I'll create a datset set called cities in my report setting its...

I think I need a table valued parameter (TVP)

--Declare the type

CREATE TYPE testType AS TABLE

(

Parameter varchar(40),

ParameterType varchar(40),

ParameterValue varchar(100)

);

--Create a procedure that accepts a TVP

CREATE PROCEDURE dbo.uspMasterParameters

@TVP...

If you can't put the horse back in the barn then I am not sure what you can do.

Options seem to be:

-modify the existing linked server to point to the...

I have moved away naming linked servers using either server-specific or even database-specific names.

It creates confusion when a server goes away and all your code refers to something which doesn't...

Thanks All,

My option seem clear.

1) dynamic sql

2) The easy and one could argue proper way, IF @SelectType = 'ALL' ...ELSE...

3) My mini hack-SET top to an arbitrary maximum number

I may...

Sure and I may go in that direction depending if there are other options.

Downside to forking the code is my actual situation is a bit more complicated and there would...

If you are really on SP1 you will have to decide whether you are going to install the latest service pack or not.

If you want to proceed search 'SQL Server...

Refer to this and let us know the results.

http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html

Did you get this information by running @@VERSION in SSMS/Query Analyzer?

If you are on SP1 you will need to apply the latest service pack, SP1 I believe, and run the...

Whats the service pack level of the SQL Server 2000?

Ok, thanks, it sure seems like REPLACE would be the way to go.

Views don't seem possible.

This is invalid syntax because of the parameter.

CREATE VIEW myView

AS

select REPLACE(footer,'@client',@client) from Footers

I'll probably use...