confirm.

Note that your <column> can be multiple columns, and the sort order can be ASC or DESC on each column.

You are actually creating a tab and a named range. Since the named range cannot have spaces, any are converted to underscores.

Another use is in auditing... if you want to audit what...

Charlotte,

It wasn't you... the...

AVB (1/29/2010)

---

I'm not quite sure how to do this with a trigger. I can't get the Modified value from the Inserted table because there is already data in the "Modified"...

Charlotte,

First, I want to thank you for providing DDL/DML to show what your working with.

Now, this just expands on what you've started.

--===== Split or "Normalize" the whole table at once

;WITH...

Ideal world: the columns that define a PK will NEVER, EVER be changed.

Real world: invariably, some...

Lynn Pettis (1/29/2010)

---

.... You should also script out all jobs in msdb. Probably all the logins (sans passwords) in master as well. You will have to deal...

san43 (1/29/2010)

---

We have a stored procedure which was running fine from 5 years but now it is running very slow. It is using table variables to load data from select...

stricknyn (1/29/2010)

---

This should be pretty straightforward, but for some reason its not working and I can figure out why.

I included the SELECT portion. The error I get is

Msg 102,...

I haven't used OpenRowSet to open up a csv file before. You may need to use OpenDataSource instead.

In the meantime, here's the sp_OA method:

declare @FileName varchar(100)

set @FileName = '<Put your...

Makes up for yesterdays (though points were awarded anyway...)

Would you care to elaborate on how a set-based method is...

As others have already mentioned, sys.tables will show the time the structure of the table was last changed. And you will need a trigger to show when the data was...

The can think of of two ways:

select *

into #temp

from OpenRowSet(...)

where 1=2

select count(*)

from tempdb.sys.columns

where object_id = object_id('tempdb..#temp')

drop table #temp

and use sp_OA...