Althought _ is a great option to % especially for fixing positions I would still need to know exactly how they stored it. Personally I use decimal(16,0) and let the...

It can be done to mark a table as a system object but that requires going out of your way to upset the sysobjects table manually or use sp_MS_marksystemobject procedure...

First off where does firstname last name come from?

I asume from your query it will be from the o_file table possibly but I don't see a column that says it...

DBA 2 because of the setting for unrestricted growth. Only once all HD space is exausted will the Log file fail becuase the is nothing it can do at that...

To my absolute best knowlegde that answer is know. Although installing Firefox really was a bad idea it should not have tampered with any System DLLs that would have effected SQL...

The big difference is in the exists for tripacc which you make two different hits on.

I would be curious if this doesn't produce the same effect. '

SELECT count(*)

FROM   address...

Or with ADO use a Command object and pass each input as a parameter. When you do so it will auto handle these situations better than trying to remeber to...

In your case you might want to consider storing the number twice and use a bigint or decimal(16,0) datatype.

The first field would be stored in left to right order, the...

Go googling for DMO info. Ask specific questions.

Hadn't noticed before but looks like wizard doesn't support dealing with the password.

You really did do a nice job on this article. Very complete description and nice use of visualizations to send home.

Are you sure you are looking at the right thing? Can you post a few links so I can see what you are reading?

Have you checked out this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefindservprovspec.asp

Which is the greater amount, the first or the second? I suspect it is the first which if so check your datearchived column for any values of 1/2/1900 as that...

But why not just write in VBScript as that is a language option for a job step? Much simpler than trying to use sp_OACreate and stuff.

Yeah, there was a topic on this a few months back where someone was showing this and questioned how it happened. And there may have been a Question Of The...