If you login to sqlserver sql as a non sysadmin, you should be able to define the wanted schema as default schema for that account.

btw MS has published a tool...

We use @temp tables to provide a usable example.

Just replace the table name in the query and use the currect column names and you should be fine.

I'm glad it could be of use to you.

We haven't encountered the issue on any other servers (yet) and still don't know what caused the files to be missing.

- there are a number of split functions available at SSC.

- or you can use a combination of :

e.g.

left(yourcol,charindex(':', yourcol)-1)

and

right(yourcol,datalength(yourcol) - charindex(':', yourcol)+1)

how about an hard IIS reset or "recycle" of application pools .... can that be causing the issue ?

See the IIS logs.

Kent Zhou (4/16/2009)

---

Thanks, guys. I found the solution.

The solution is restart DTC service, not need to restart the engine.

But what I'm confused is: why Begin distributed transaction doesn't work...

Certainly no blame Gail 😉

Chances are I misinterpreted the advise and may have taken it to be applicable for as well dbcc updateusage as well as sp_updatestats.

Once again proves we're...

Hi Gail, it must have been on 2009-03-10.

That's the date I modified my rebuild proc.

My "my posts" history only goes back til 2009-03-11 🙁

venu_ksheerasagaram (4/16/2009)

---

venu_ksheerasagaram (4/16/2009)

---

Hi friends

...

'sp_OA***' procs have always been on a bumpy road.:sick:

With sql2005/8, if you can, convert all extended sprocs to CLR modules.

it the rollback takes to long, just stop/start sqlserver.

Also keep in mind, this rollback may cause issues on your linked server (if updated).

In that case, what would be wrong with this ?

/*

What would be wrong with This solution ?

Keep in mind it starts with date 1900-01-01

*/

;With cteSum

as (

Select sum...

You need to add the date column to your time column or you will end up with negative times

Work with datetime datatype so at the end you just need...

With sql2000 I used to run sp_updatestats and dbcc updateusage (0) with count_rows after the...

There will be an overhead when deleting rows, and because the dependant table will be empty, that overhead will be minimal.

But If you have control to that process, you could...