Thank you and thanks for pointing out my error on the first one. Helps to have more than one set of eyes on a task always.

Sounds right but I am trying to verify to be 100% sure on this.

I believe all you are missing is the OUTPUT keyword with the parameters that are accepting OUTPUT. But try this.

declare @out1 varchar(50)

declare @out2 varchar(300)

exec usp_GetDesAndPopup @tablename = 'tblIANMain', @languageID =...

I believe it is accurate but it is also subjective to various factors. Unless you are running on a system with no load and you use the DBCC processes to...

I think SQL pulls some odd crap sometime. The adding a column with a default of 0 with ALTER should have done just as quick. So obviously it does something...

Try this for the procedure side.

CREATE PROCEDURE usp_GetDesAndPopup

@tablename sysname,

@languageID int,

@entityID int,

@Descriptionvarchar(100) OUTPUT,

@PopupTextvarchar(100) OUTPUT

AS

SET NOCOUNT ON

DECLARE @sqlstr nvarchar(2000)

SET @sqlstr = 'if exists (SELECT @Description = [Description], @PopupText = PopupText FROM EDB.dbo.'...

Trying to get to a point here now where we will be able to seperate all our online apps to their own servers. In the past on some I have...

I haven't had a need for this myself so had not explored. But seeing it here gives me an idea what to do if I ever do need. Good article.

...

If you knwo roughly when it is occurring everyday do a general trace on SQL statments begining with Profiler. This way you can get the order of events occurring that...

Looks like a documentation error. The /3GB to my understanding to allow applications to reach into that extra GB that otherwise the OS would own in native mode. Apps 2GB...

Try this using a Stored Procedure

if exists (SELECT [Description2],PopupText2 FROM @tablenameTranslation WHERE EntityID2 = @entity AND languageID = @languageI)

begin

SELECT [Description2],PopupText2 FROM @tablenameTranslation WHERE EntityID2 = @entity AND languageID = @languageI

end

else

begin...

If this is the first time it is hard to say. I recall seeing this mentioned happening before during the population of the Fulltest search. However you need to get...

Write a simple VBS file like so.

MsgBox "Test"

And save as test.vbs

Double click and see if runs.

If you get a similar eror or don't see the message box with Test popup...

I am trying it now just to see for myself. I find it simple to use but missing a few features or more specifically comparision option settings, and even more...

Could be a number of things. I am not really sure the CPU time is accurate thou as I see various results that I cannot get a picture of anywhere...