The trigger is in the same transaction context of the DML that inserts the order into your table. The transaction will be promoted by MSDTC to a distributed transaction since the trigger asscess...

512MB is low for heavily accessed system with big database.

But for a samll database with moderate load, it's not so low. I have a db server (Win2003+sql 2000) dedicated to an app....

THis is not supported.

Instead of view, you can define a table valued function, which supports local variables etc.

in most cases, a table valued function can be used in the same...

1. I cannot figure out any impact on performance or response latency.

2. It depends. If all these apps require similar priviledges, using the same login decreases the logins exposed to the outside, and...

In your update trigger, add the following:

IF UPDATE(EmployeeColumn)

BEGIN

--Your code here

END

You can  use xquery function to achieve this. CHange your query to:

SELECT

FunctionId, FunctionName, FunctionDescription, Parameters.

You can SELECT the pivoted data into a table:

SET @sql=LEFT(@SQL,LEN(@SQL)-1)+nchar(13)+

' INTO YourSecondTableName '+

'FROM YOurTable GROUP BY ...

There are several posibilities:

1) You may have memory leaking in SQL. E.g. if you use sp_xml_preparedocument and forgot or bypassed sp_xml_removedocument.

2) You may need more RAM.

3) It may be caused by...

What you are trying to do is to pivot the data in your table. The following code will do this (correct any syntax error):

DECLARE @Properties TABLE (PID int identity NOT...

Add a database role, user, or windows user/group to a database role:

sp_addrolemember @RoleName, @MemberName

There are some breaking changes. Please check ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/47edefbd-a09b-4087-937a-453cd5c6e061.htm in BOL.

The test will be the last say. Take a backup of your current db and upgrade to 2005. Test your ERP application.

You do not need to create the temp table in VB. It should be in your main SP your VB code is calling.

In your VB code, you need to compose an xml document...

I saw you are using IN expression so I assume the @search_clause_?? are just values for the column @column_name.

You can create a temp table #ColValues and save all searching values into...

I don't know why the user still cannot see the processes in EM, but you can let him run sp_who or sp_who2, or select * FROM master..sysprocesses.

Check the login column...

Who is the job owner? you need to set up job owner. You can use the same account as the one you used when you manually ran the SP.