George,

You're absolutely right! Didn't think of that. I used windirstat and there are some files from the backup client there.

thank you.

It was the GetDate(). Something so simple.

Winded up declaring a variable and setting them like this:

SET @SPRCMNT_ACTIVITY_DATE = GETDATE()

SET @SPRCMNT_CONTACT_DATE = GETDATE()

Then in the query, changed it to this:

SET...

Thanks Mark, actually I started with a CTE and got a little stuck, thank you for the input.

I usually create a role and grant execute permissions to that role then assign a user to that role.

I never did figure this out, so I kind of put that piece of project on hold. Hopefully someone will find something and share with us.

No control over the file. 🙁 Thanks for your suggestion I was afraid of that.

I believe you can use sp_updatestats

so for temp db, its recommended to have one drive for ldf and another for the mdf?

Thanks for your response Jeffrey. Clears up a lot of things now.

Thats it!! thanks G2.

Thanks Seth, I had actually figured it out last night, but I didnt have access to internet to post. thanks for your input. 🙂

Yeah guess it was permissions. The linkedserver user I am using only had datareader on the remote box. What is weird though, the table function doesn't have execute permissions on...

Well I am SA on both boxes, and I was the one who created the functions. The table function works fine from the same remote box that I am trying...

AWESOME!! Thanks jeff

Ok I almost got this working with the following code....

OPEN GetProcedure_Cursor

FETCH NEXT FROM GetProcedure_Cursor

INTO @QuestionProcedure, @QuestionID

WHILE @@FETCH_STATUS = 0

BEGIN

declare @MyString varchar(8000)

set @MyString...