CAST and CONVERT cause syntax errors in Index Server.

Index server SQL looks like "proper" SQL, but as I said, it seems to leave out all the useful bits!

If you look on the Microsoft SQL Server site you will see that there is a books on-line update dated January 2004.

You can tell if you need the update by...

Return values are integers.

Alter your stored procedure and read the recordset returned from the stored procedure.

CREATE PROCEDURE test @log_id as int

AS

SET NOCOUNT ON

select solution from dbo.tbl_mis_log where log_id=@log_id)

GO

I've found srv.h in the examples file and it looks considerably different to the one in the visual studio directories.

Temporarily I have replaced the vs version with the ODS version...

Marvellous isn't it.  Bet it happened in a busy period as well!

I've had it happen to me and the only thing I could do was rebuild the server, reinstall SQL...

Unfortunately this is one of the problems with user defined datatypes.

You can update them, but they don't affect existing definitions within tables.  They act as a template at the time...

SELECT TOP 25 * FROM Products WHERE ProductID NOT IN (SELECT TOP 25 ProductID FROM Products ORDER BY ProductID) ORDER BY ProductID

Presumably this was for the Northwind database?

SET FMTONLY on

GO

USE...

Interesting point this.  An unscrupulous supplier could come up with a dodgy QOD on purpose!

Found it!

USE master

EXEC sp_configure 'max text repl size','<<size up to Gb expressed in byte>>'

RECONFIGURE WITH OVERRIDE

The default value is 65K

Have we beaten the flame record set by Steve's Ronald Reagan post yet?

As the author of the question has already posted, what they were trying to get at was that the USE statement doesn't work when the SET FMTONLY ON command has...

If you are a creationist then the chicken.  If you are a Darwinian then the egg.

I'll play devils advocate and say that the trick questions are more relevant because it...

I don't think replication is the way to go on this. 

If you are doing stats analysis then this, plus your comment about copying files, suggests that your dataset is...

I'm afraid it doesn't help.  These are precisely the steps I am taking in any case.

sp_attach_db reports that model has been successfully attached, but it is lying!

I'm not sure if you gain anything with small VARCHAR fields because the nature of a VARCHAR is that it needs to store its start and end point.

A VARCHAR(3) could...