Not sure what you mean by post. Yes, you can use sp_oacreate.

Whether or not them querying the server is bad depends on the query. I've got an app coming up...

No need to do transaction log backup if you change to simple. By not doing them (and using simple) you have the ability to restore to the last full backup....

If you're not going to do transaction log backups I'd recommend that you change the recovery model to simple. That will allow SQL to automatically truncate the log once the...

What do you have the recovery model set to? Are you doing transaction log backups? You can use DBCC shrinkfile to reduce the file size. Not as quick as detaching...

We may have a script here on the site, not sure. You could use a cursor to build it if not. Faster is to bypass the proc altogether and do...

At some point you reach the limits of what is practical in a trigger and need to move to more of a batch process mode. Inserting the pkey in a...

I like permanent tables too if it will work in the situation (sometimes you may have different cols each time).

Andy

http://www.sqlservercentral.com/columnists/awarren/

How will you do the broadcast? You typically should not return anything from the trigger, so the next best thing is to write what you want to broadcast into a...

I do not. In cases where I need the proc available in every db I just add to model.

Andy

http://www.sqlservercentral.com/columnists/awarren/

This may help:

http://www.sqlservercentral.com/columnists/awarren/sqldmorestore.asp

Andy

http://www.sqlservercentral.com/columnists/awarren/

Snapshot and transactional both hold locks when you run the snapshot job. There is an option for transactional to use the concurrent snapshot which does not hold locks, but only...

Havent tested. Has to be some overhead, though I suspect its not a lot.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Try HKCurrentUser\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\RegisteredSErversX\SQLServerGroups.

If you're using NT security you should be able to add all at once, if they show up in the browse list.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Sounds like a problem with quoted_identifier.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I'd recommend looking at the query plans. Possibly the optimizer is making bad calls (which could just be bad stats as Antares suggested). You might try adding with recompile to...