IMHO Datetime is the correct datatype for it. just because you don't want /need the day information doesn't mean its not right.

Just store the day as 01/10/1900 and then the...

No lock is not assumed.

You do not want to use Nolock haphazardly. You should use it in very specific places. Because of the potential for a dirty read, No matter...

No, you cannot use dynamic sql inside of a function.

What exactly are you trying to do?

No it does not.

Wizard is there for quick simple wham bam Thank U maam type import.

Script the table w/ indexes triggers etc before hand,...

No, Not a simple query.

In sql 2000, you can use a function.

Works well,

-- =============================================

-- Create scalar function (FN)

-- =============================================

IF EXISTS (SELECT *

    FROM   sysobjects

    WHERE  name =...

UPDATE products

 SET productdetail = @detail,

 productprice = @price

WHERE productid = @id

  and @price is not null

Each different select statement is a different recordset.

Try putting them all into 1

select 1 as property,

       serverproperty ('servername') as 'Server',

       isnull(serverproperty ('InstanceName'),'') AS 'Instance Name',

       serverproperty ('edition') as 'Edition',

      ...

Is there any reason why your not/cannot use windows authentication?

If so you wouldn't have to worry about this.

But if not. There's really no "Easy" Way.

Sql really wasn't desgined to be...

No because you'll have to open a port in the firewall which will expose your sql server to the world.

Microsoft has an "Add On" of Notification services, perhaps you could write some code to extend it and do this.

Generally I avoid emailing things externally (Out of the network domain)...

Are you going to do this in Sql server, or in vb.net?

If vb then your going to have to read the file line by line, and parse the lines by...

Yeah, I would put some additional field in that table that even can have like a Guid, and then only export values with that guid. But if you can control...

Asside from changing the data model (Not saying you should, or should not) but joins perform poorly when an or is stated in them much as it would if you...

Unfortunatelly its not that straitforward. I do not know of third party tools to help with this.

but as far as sql. its a little painful.

I don't know your architecture,...

When you are creating join criteria it is formattted as.

join table on somefield = somefield

            and SomotherField >= SomeotherField

etc.

Your join has

(qf.sy_templateid = c.sy_templateid and qf.qstid = r.qid )

which is fine.

But this...