You review some utility code that uses DMO...

You write a small VB6 utility app that...

SQL-DMO can be used from which of the...

Using SQL-DMO, which of the following will allow...

The abbreviation DMO means what in SQL 2000?

RE: Elapsed time doesn't match clock

Sorry should have read closer. You ran it into a temp table. Above wouldn't apply.

RE: VBScript running from command line

Thanks MW. I'm using stored procedures and the logic looks simple enough. Maybe 24 hours is as good as it gets.

RE: Is the Schema Still Needed?

I liked the idea of developing and testing with your own "schema" before cutting across to a dbo implementation. It is not a facility that I commonly use and I don't know many other people who do. The problem is that if you work in a shop where no-one else uses a facility then who […]

RE: SqlServerAgent fails

Make sure this domain account is in your SQL Server logins with 'sa' right.

RE: Calculations with Queries

Not to beat a dead horse but it is an interesting problem:-) How about something like: for table junk -- create table junk (a char(15), b datetime, c int) create table #tom (z int identity, a char(15), b datetime, c int) insert into #tom (a, b, c) select a, b, c from junk order by […]