Use an INSTEAD OF Trigger and if number of rows is greater than the amount specified then do a ROLLBACK TRAN

Edited by - noeld on 11/25/2003 10:58:49 AM

How About:

--First Add the Column

Alter Table ConfigInfo Add DBName nvarchar(128)

--Then The meat and potatos

 



exec sp_MSforeachdb 'use ?  

  insert into Admin.dbo.contigInfo

 ...

Check this:

- if any view that is beign scripted is trying to access a linked server that not longer exists it won't work!

- are you selecting the "script all dependent...

have a look at xp_stopmail!!!!

1. I have around 150 views and ALL can be scripted out. So I don't know what are you talking about.

2. Are you using anything special like schemabinding or are...

can you SEPARATE The Three components into COLUMNS. It is going to me ALOT easier to maintain, simpler to query against an probably Faster!!

HTH

is just a TABLE in the master db

you could use it instead of sp_MSforeachdb 😉

with crossdatabase ownership enable a user that has db_owner permission on database "A" will automatically have db_owner permissions on "B" I don't know if you would like that, its very...

1. What SP Level do you have ? (SP3a)

2. Are all the objects owned by dbo?

Are you using :

sp_MSforeachdb 'use ? dbcc showcontig with tableresults, all_indexes'  

Remember it coms back as Multiple RS

HTH

Yes.

You can use 3 part Name like [DBname].[tableName].[Column] on the FROM Clause, but you must be aware about the crossdatabase ownership change. If all aobjects are ownned by dbo and...

I would do it the other way around.

1. Sql Server is a Service so you don't have to "wake it up"

2. You can create a Linked server to the Access...

Use a stored procedure pass the strings as variables and then you can handle them with:

QuoteName(@VariableWithQuotesInIt ,'''')

If the Admin Account has a NULL password Jet authentication is not good. Try changing Admin password to other than Null

Sorry NO SQL COMMENTS are supported in Jet