Thank's a lot Mohit.

You are right : I should have posted this tread in the SQL Sevrer 2000 Forum instead of the SQL Server 2005 one (it would have been...

Hello Mohit,

Yes I know that sqlcmd offers a lot more flexibility for that purpose but we are stuck with old SQL Server versions and, in the same time, have to...

Thank's a lot and have a nice Day Andras.

Thank's Andras,

Can I get back the result of the execution of @q and use it afterwards?

Best regards.

Carl

Thanks a lot David,

Here is what I will use:

[font="Courier New"]IF OBJECT_ID('tempdb..##MyOtherUserName') IS NOT NULL

DROP TABLE ##MyOtherUserName

CREATE TABLE ##MyOtherUserName(UName varchar(30))

DECLARE @stmt nvarchar(500)

SET @stmt = 'use E'+char(10)+'INSERT INTO...

Thank's David,

this solution requires the login to have sysadmin and securityadmin fixed server roles.

Not my case. 🙁

Anything else?

Best regards.

Carl

Hello Matt,

thanks a lot for these precisions.

Carl

Hello Jeff,

What I was looking for is if someone was aware of which part of the NEWID() value is the result of the CPU clock and which part is the...

Hello Wayne,

It was in 2005... One year in IT and you see a lot of things...

I don't remember this particular case.

Maybe it was corruption in the database that we noticed...

Hello Steve,

Its because I wanted to be sure Named pipe was not used without having to reconfigure the client network utility.

In fact its a longer story...

Our app is using ADO.NET...

Hello Sugest,

I also tried with a static port for the named instance and the same problem arise.

Regards.

Carl

I was not sure but now I am: Service pack 4 solved this problem.

Regards.

Carl

Thanks Michael,

You seem to be rigth. Its different from Oracle that compile the entire script not only the code that is executed in fact.

Its strange because we've tested it last...

Thanks David,

The only part that was missing is the "@count OUTPUT" at the end.

Yes I need to do dynamic SQL because in my particular environment, this script can be run...

Hello Lowry,

I applied hotfix 933097 (Cumulative hotfix package (build 3152)) and it seem to have solve our problems.

Regards.

Carl