Apparantly my ramblings were dated - pre 7.x behaviour and all

Here's an interesting article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/Sqldev_02252004.asp for the daring, describing the inner secrets of...

I doubt that anything less than admin could get at this info. Having said that, no, I have no clear idea if it can be done, or how.

Well, I'll try to come up with some good advice then

Firstly - forget 'display dependiencies' - it doesn't work like we want it...

save this as chkDB.cmd or similar

-- start file --

@echo off

osql -S%1 -E -Q"EXIT(select count(*) from master.dbo.sysdatabases where name = '%2')"

@echo on

IF %ERRORLEVEL%==0 ECHO Nope

IF %ERRORLEVEL%==1 ECHO Yes

--...

Perhaps ypu could give us some details of things you've done, stuff verified to work / be configured as expected, how it's configured, what's been tested, what's been not etc...

/Kenneth

I use it mainly in two ways:

1) errorhandling.

.. do some stuff

SET @err = @@error  -- NEVER check errors directly on @@ERROR, always use a local var

Ian,

you omitted the select part from your reindex cursor, but I think it's fair to say that what it does, is to run DBREINDEX on a number of tables, correct?

Since...

Have a look at osql.exe in Books On Line. Perhaps you can adapt EXIT or RAISERROR in some useful way.

eg DOS_variable = osql -S %server_name% -U sa -P %sa_pwd% -d...

AFAIK, there is no easy way to determine if a view is updateable or not.

The first 'problem' is - what is an updateable view? There may be several different definitions...

Ah, I see.

This would probably be easiest by DMO (same stuff as EM uses) Probably someone has already put something together for this...

Okay, so that means that each child knows which is it's parent.

1 1 Rough Purchase  0 

2 1 Purchase Requisiton  1 

3 1 New  2 

4 1 Edit  2 

5 1 From PO  2 

6 1 From Process  2 

7 1 Rough Receipts  0 

8 1 From supplier  7 

9 1 New  8 

10 1 Edit  8 

11 1 Delete  8 

Which then would bring the above to a like tree

          0...

I would guess closer to you than me

Good luck hunting - it seems to be a tricky one. Have no bright ideas at...

Any hierarchy represented by child + parentid is 'by design' not performance oriented in a relational language like SQL. SQL is simply not suitable for hierarchies of any kind. It...

Again, why would one want to do that? Generating databases automatically is in general not 'normal', so to speak. Is there any special circumstances which makes this the 'best' choice?

/Kenneth

If the child has knowledge about it's parent, then you can walk that way in much the same fashion. If the child does not know which it's parent is, then...