Two things:

1. Change your SET statement like this (note the space before EXEC):

set @query_rapport = 'USE ' + @dbname + ' EXEC sp_change_users_login ' + @parameter

2. Since sp_change_users_login requires...

Did you check this out? http://support.microsoft.com/?id=830215

Briefly, the cause is:

This problem occurs because the SQL Server service account is not a member of the local administrators group on the computer....

If you use full-text searching, you must grant the NT Authority\System sysadmin rights to SQL Server if the Builtin/Administrators role is removed:

EXEC sp_grantlogin [NT Authority\System]

EXEC sp_addsrvrolemember @loginame = [NT Authority\System],...

I have a zipcode database that's been cleaned up a bit to fit my needs. It contains 42118 zipcodes. A table of distances between zip code pairs will require C(42118,2)...

Another way is to use the position number, which for the UDF in this case is 7.  Be aware that this method is not recommended, because if you change the...

What are you trying to accomplish?  As Allen mentioned you've reversed the Cr and LF. However, even when that is corrected, the output you are trying to run with xp_cmdshell...

Of the three types of UDF's, only scalar functions (functions that return a single value with the RETURN statement) allow the results of other functions to be passed as parameters. ...

I'm not sure I completely understand your question, but see if this example helps:

DROP TABLE codPostTest

GO

CREATE TABLE codPostTest

(

  id int IDENTITY(1,1)

, codpost varchar(20)

)

GO

SET NOCOUNT ON

INSERT codPostTest (codpost) VALUES...

If you know the column name ahead of time, and I asusme you do because you seem to be passing the column name as a parameter, you could make a...

The only objects I place into my COMMON database are generic SP's and UDF's that don't reference external objects - they operate solely on parameter values. Things like string parsing...

Maybe this will point you in the right direction:

http://support.microsoft.com/kb/322144

How are the lines skipped?  I note that 185/2 = 92 plus 1 row. Are you importing every other row? Maybe each pair of lines is being treated as a...

Another option is to edit your SSC profile, and check the "Disable WYISWYG Forum Editor (faster page display)" option near the bottom of the page. Of course, then you can't...

Type Shift-ENTER instead of just the ENTER key.

Here's a variation of the above reply that uses a loop instead of a cursor:

drop table Employee

drop table EmpDept

drop table Department

go

SET NOCOUNT ON

create table Employee(emp_id int, emp_name varchar(10))

insert into Employee(emp_id,...