or even

  exec sp_msforeachtable 'sp_spaceused ''?'' '

{note: two single quotes around the ?}

David

Hi Mike,

found a further article at http://www.intelligententerprise.com/001020/celko1_1.jhtml

It appears that if your organisation structure fequently changes, you would still need an adjacency list to calculate the nested sets though? Joe...

Hi Tim,

Thanks for that link to Joe Celko's article, I had not come across this solution before. I can see that it is easier to model an org tree in...

Hi Mike,

apologies for this, but i am interested in your right-brain set based solution, but I am feeling a bit left-brain this Monday morning, probably lack of coffee, so please...

Thanks for all your help guys.

I managed to resolve the problem using the solution you provided. We are upgrading our production server from Win2k to Windows 2003 next week, so...

Hi,

I don't have time for a full analysis, but a couple of thoughts came to mind immediately.

I have found from experience that updating temporary tables and table variables tends to...

Hi,

any recent changes to the network environment, such as numbers of users, changes to network security, recent service packs applied etc?

David

Hi SQL Oracle,

Thanks for that information, you were right about the user being orphaned from the login.

I checked the sp out in BOL and used the following syntax...

sp_change_users_login 'Update_One' ,'dbuser',...

Ok,

as I suspected. After initially creating the database with DTS, when I ship copies of database and transaction logs and restore using  RESTORE ...WITH STANDBY, the database access granted to...

Thanks Ron,

I have tried that but it didn't work unfortunately.

I am thinking that because I initially set up the database using DTS export, and used the option to copy all...

This is a great idea, I am going to use it in my application. I have re-written it as a function though  (for consistency with standards of my system) by...

Table? You should have put in  'Normalization' as a gotcha

Now if it was a partitioned view...

David le Quesne

Just re-reading my posting, I realise I should amend my signature to 'If it ain't broke, try and break it'.

I ship logs every 15 mins to a warm start server,...

Hi Steve,

Nice article! Being a one-man DBA/developer in a small company, where nobody really understands what a DBA is/does, an article like this really underlines the usefulness of this website...

Thanks Mike, a very interesting article.

My first thought on reading this was 'Yes well it's all very nice in theory, but not much use in the real world'. Then...