To connect with a standard SQL login, you could try something like the following (of course, change the user id, password, server, and database):

Dim strLoginID

Dim strPassword

Dim strConnect

Dim objConn

Since the tables involved in your query are structurally identical in every database, you could name your stored procedure sp_GenSelect and create it in the master database. The SP can then...

It doesn't cause any problems other than a possible invalid or null value for the global variable @@servername.

What do you get when you execute

SELECT @@ServerName

Of course, you must stop and...

To use UPDATETEXT to append text, use the following template:

DECLARE @tptr varbinary(16)

DECLARE @textToAppend nvarchar(4000)

SET @textToAppend = N'your text'

SELECT @tPtr = TEXTPTR(columnName)

    FROM...

The BULK INSERT statement will implicitly convert varchar to nvarchar if necessary.

The problem is you're missing a single quote after the filename.

Change this:

set @cad='BULK INSERT webmisco.dbo.wr_primero FROM ''d:\transferencia$\web\reports\'+@Fichero+'...

Since you didn't post the DDL for the view, we can't tell exactly what the problem is. Open SQL Server Books Online, select the Index tab, and search for UPDATE,...

I'd take Remi's advice and drop the server, then add it back in:

EXEC sp_dropserver 'yourServerName'

EXEC sp_addserver 'yourServerName', 'local'

Stop SQL Server.

Restart SQL Server.

Also, try either or both of these: