Hi

I wouldnt say no straight out. Sure, its not ideal, but using fg's to seperate out objects (ie. data vs index or audit objects) isnt a bad thing and...

well blow me down..

the table is empty, the space usage reported by dbcc tab and dbcc page was still marking the pages as being used by the object. This...

Hi Robert, good article, ive used this sort of technique with large data migration efforts and works well. I cant only dream for managed exception handling for t-sql in...

Hi

The biggest ive seen to date hosted in oracle is a 450Gb beast. The size is one thing, but really high throughput db's and massive numbers of users is...

Hi there

Yep, the KISS methodology is always the best option. Wrapper in and transaction perhaps just in case there are issues, or goto temp tables first then "cutover", its...

Hi

With the info provided, I would consider replication, simple enough and effective. Do you need to go back the other way or it will be 1-way replication only? ...

Hi Steveo

Long shot #1 - Did you profile the statement? checking the execution plans very carefully.

Long shot #2 - any other jobs running, run perfmon at the same time with...

Hi there

Your in luck, we do this all the time, not huge numbers of users mind you (perhaps 5 concurrent max at times), but still, files are big. We...

Hi

Im an SSWUG member, its pretty good as a general portal and cheap- main thing i get from it is the daily emails re key events and happenings in 3...

Hi

a) service account login name changed? password invalid, accont locked etc? (try admin account 1st then move back to other user name)

b) messages in the event logs?

are...

Hi there

Its very simple, lookup BOL on "FOR XML" and have a careful read, the developers here use FOR XML RAW and whack it directly into the MS DOM for...

use this:

create table #mytmptable (<etc>)

or the double ##

as mentioned, if you want "perm" temporary tables for general working purposes, then I would rethink what your trying to do here. ...

Hi Len

If you want any more details, feel free to email me off line, more than happy to share leasons learnt etc.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle...

hmm.. i was trying to get out of that 🙂 but no matter, thanks for the post.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi

Interesting problem..

8.00.679 SP 2 + Q316333

8.00.534 Service Pack 2

Try applying Q316333 and try again.

See http://www.krell-software.com/Resources/mssql-builds.htm

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"