did you create the proc on this server, and put it in the master database?

remember you also had to mark it as a system procedure with EXECUTE sp_ms_marksystemobject 'sp_spaceused2'

like i...

the USE <dbname> and the EXEC sp_....have to be in the same EXEC statment....otherwise the fiirst one, just use <dbname> goes out of scope when the the eXEC finishes (instantly)

declare...

ok, i just googled "Non UTF-8 Characters", and the only thing i can find is when something got malformed; otherwise, It looks like UTF covers teh whole range of...

LinkedServerName.DatabaseName.SchemaName.TableName.

i doubt very much you have a schema name named GT_GEARS

it's much more likely that it should be EDWGEARS.GT_GEARS..VW_GEARS_REPORT_DATA

...

I'm trying to find the thread, but we once did a specific test here on the forums about whether there is a performance hit on whether you explicitly drop a...

into #temp

double check your code:

the only thing that does is create a temp table.

then it leaves at the end of the procedure.

maybe you wnat to SELECT from that temp table...

anthony not sure if you have seen this yet;

there's a helpdesk app called ZenDesk (no experience with it, sorry), and there is a codeplex project that integrates Zendesk with TFS...

It's a holdover from how my scripts get deployed; trying to avoid GO statements, so everything gets wrapped into dynamic SQL for...

the table layout is critical here. you've got to provide the DDL to get a good answer;

are Astore and bstore columns in the same table, or two differnet tables? or...

I tend to simply check for the object_id a lot:

I also tend to put the command for create/drop/alter for the table in dynamic SQL to avoid syntax checking.

IF OBJECT_ID('ABC_School') IS...

eugene.pipko (8/22/2012)

---

Thanks for reply. I like the idea of adding the schema to what I already have. You wrote:

<quote>The other thing you might do is take sp_spaceused, get the code...

Sweet! glad that worked! I know I had installed it once on both a 2005 32 bit,...

Excellent! glad this...

the error is occuring in the UDF itself, it looks like; can you post that? we can help you rewrite it to avoid that error.

i think what you want is instead of the web client, say executing a stored procedure that does a bunch of work, you want to have the web page activiate...