Index property works just fine there too.

select object_name(id), name from sysindexes where INDEXPROPERTY ( id , name , 'IsClustered') = 1

Use that within an openquery and it'll work. Or you...

Then why is the DB in full recovery? If you're in full recovery and have no log backups running, the transaction log...

Then the log file size isn't related to replication. Snapshot doesn't use the tran log. It just copies the entire DB to the subscriber. Since the DB's in simple...

What recovery model? Do you have log backups?

What type of replication? If transactional, is the log reader agent running properly?

What does the following return for the DB in question?

SELECT name,...

What are you trying to do with triggers?

What were you trying...

How often do you have log backups running?

There's no DDL triggers on SQL 2000.

Set up a job that checks for new DBs (maybe against a table that stored the ones that you know are there) and...

select object_name(id), name from sysindexes where INDEXPROPERTY ( id , name , 'IsUnique') = 1

I'm...

Null comes first because SQL has to do a sort behind the scenes to ensure uniqueness (required by union). Hence there's an implicit Order by 1 ASC on the statement....

View definition is not a permission level in SQL 2000. It was introduced in 2005 along with the tightening of the metadata security.

In 2000, iirc, everyone could view the definition...

It's possible, it's not usually a good idea. There is a max permissible recursion level of 32. If you go past that, the trigger will fail and the whole lot...

There's no such command as ALTER RESOURCES in SQL 2005.

Could you please explain...

That's not how you get a value from a table in SQL.

SELECT @UpdatedVendorID = [Vendor ID] FROM #myupd

Also, what's going to happen if more...