The stored procedure is designed to search for columns and records where a supplied string is contained within the column.

Numeric datatypes won't work in this way. What exactly is...

The difference is that an entire system would stop functioning correctly if it couldn't cope with the rollover to a new century, where as if you don't use XML....so what?

As far as I am concerned XML was supposed to be something that separated out content from presentation for the web. It was a development of SGML.

I agree with...

What happens if you create and explicit temporary table of the require structure and do several insert selects instead of the union query?

There are 2 parts to this.

DATEPART returns an integer and therefore you must CAST or CONVERT the returned value if you want to concatenate the string.

SELECT DATENAME(MONTH, DATE)+', '+ CAST(DATEPART(YY,DATE)...

EXEC sp_attach_db @dbname = N'<>',

@filename1 = '<>',

@filename2 = '<>'

Well, if all you are doing is SELECT then I would guess that the offending column in one of the tables in the VIEW is NOT NULLable.

When the UNION operation...

I could be getting mixed up with Clustered Indexes here but I thought a primary key had an affect on the maintenance of other indices. something to do with...

Anything is possible given time and money.

There are probably ActiveX controls out there that will do exactly what you want.

I would not feel comfortable letting users fire off queries without...

Be very sure that you are in the correct database when you run this.

DECLARE @sObjectName NVARCHAR(128)

--Loop through all table objects.

SET@sObjectName = ''

WHILE@sObjectName IS NOT NULL

BEGIN

SELECT@sObjectName = MIN ( Name )

FROMSysObjects

WHEREType='U'...

Does your stored procedure depend on a view?

If the structure of the underlying tables for a view alter then the view can get confused as to which columns to retrieve....

SQL seems to handle it without any problems

Try select CAST(0xF43C2 AS INT)

Firstly, we always call stored procedures from our ColdFusion Apps

If in any doubt at all we pass the dates into the procs as varchars but in a known format. ...

When you say modified I presume that you mean structure rather than data? That is a column has been added/deleted from a table rather than a new record added?

There...

What is the login account for the service?

Is it the same as the MSSQLSERVER login account?

If not:

Does it have logon as service rights?

Does it have suitable permissions to run the...