Hi

Could you be more specific, please?

Thanks

Flo

Do you have administrator privileges on your box? Debugging CLR procedures from VS2008 requires to be administrator.

As Steve indicated. Do this only if you really need to.

Coupling databases over SQL - especially triggers - is a dangerous thing.

Edit: Typo

Hi

(Disclaimer: Can't try this at the moment due to a missing test system :hehe: )

The "little boxes" might appear in notepad because in Windows you need a CRLF (carriage-return line...

Hi

I'm not sure if I got you.

You can call the procedure with any answer-id and it should work fine.

Either there is a problem with your design or it works. 😛

Just...

Hi

It's not possible to use variables within XML expressions. If your node names are like "dataDef1" to "dataDefN" you can try to use the XPath functions name() and substring(). SQL...

Hi

Give this a try:

-- some vars

DECLARE

@companyName NVARCHAR(100)

,@requestorName NVARCHAR(100)

,@sql NVARCHAR(1000);

-- some parameter

SELECT

@companyName = NULL

,@requestorName =...

2000 and SQL 2005

Hi

As Lynn already suggested. You should use sp_executesql instead of concatenating values into dynamic SQL strings. Concatenating SQL with values is always a solution for SQL injection and can cause...

Hi Grant

Sorry for the late response.

Seems that the problem does not occur any more since we split the databases to different servers. We'll change the memory allocation tomorrow.

Data-center team will...

Hi Grant

I'll try to change the Min/Max Memory Allocation to same value. Do you know if we have to restart the service after changing?

Some new information