Thank you, ALZDBA, that's the reference I mentioned. It seems that the upgrade is possible for Express advanced only to workgroup, standard & enterprise...

For example

DECLARE @p VARCHAR(max)

SET @p = .....

EXEC your_stored_proc @p

I'm not sure if I fully understand you.

Does the Windows account exist? If not, create it first.

See also BOL ---> CREATE LOGIN (Transact-SQL)

Demands too many resources, isn't it? 🙂

Try to add to a SQL trace the Security Audit ---> Audit Statement Permission Event

Is there any activity involving the objects from "PRIMARY" - such as table inserts, etc ?

Do you update all the records in one operation? If yes, you should consider updating in small chunks.

Check if any locking occurs, see http://jmkehayias.blogspot.com/2008/12/troubleshooting-locking-in-database.html.

Is there any error message in your...

Did you, by any chance, create any objects in "PRIMARY"?

What about "@HeaderTag"?

What do you mean by "update row"?

You can use a "CASE" to update a column depending on a certain variable value. However, I need more info to suggest...

You're welcome, Jörg 🙂

However take care of your data when using "guest", see http://www.mssqltips.com/tip.asp?tip=1172.

You'll need the "guest" user in the other database. See BOL ---> Application Roles and http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/ ("Con: Crossing Databases Requires the guest User ")

Use a cursor to loop through databases or the sp_MSforeachdb (undocumented) procedure, see

http://weblogs.sqlteam.com/joew/archive/2008/08/27/60700.aspx

You can also query the sys.triggers catalog view.

Try something like

SET @source = '''\\server\xxxxx'''

Can you post the error message?

Don't forget to add the necessary blanks around FROM and WITH:

ET @RUNNER =

'Bulk Insert #Table

FROM ' + @SOURCE +

' WITH (ROWTERMINATOR = '''')'

For the row terminator - see BOL--->Specifying...