Hi,

Have a look at this article on how to expand a hierarchy. Hopefully that should help.

http://support.microsoft.com/default.aspx?scid=kb;en-us;q248915

Just a quick note about Peter's solution.

This will perform a mass update on all tables containing a datetime/smalldatetime column.

And I know this is exactly what you wanted.

But I'd...

Hi Devendra,

The update lock isn't placed on the entire index, the update lock will be on a specific index key range. In other words, the resource that is being...

Hi Amit,

Unfortunately this isn't going to be as trivial as running a single query because indexes (and primary keys) can span multiple columns.

So what you'd need to do is get...

Oops,

small typo there. That should be data_type not date_type.

As Peter said, let's hope that the data is actually stored in a datetime column.

Hi Andy,

You can query the sysjobservers table to get this information.

select *

from sysjobservers s

join sysjobs j on j.job_id = s.job_id

where j.name = ''

The message column contains the scheduleid of...

Jeff,

Use this query to find out which columns, and their respective tables, have datetime datatypes.

select table_name, column_name

from information_schema.columns

where data_type in ('datetime','smalldatetime')

Once you have found the table/column combination that you would...

Hi Simon,

The reason the logon is broken is because the thing that determines whether a logon is broken or not is the security identfier (sid). When you created the...

Hi,

This looks like it is most likely a conversion deadlock.

Does the column [has_commentType] have an index on it?

Also, what is the index on which the update lock has been taken...

You are right in that having mulitple log files on the one disk can result in the heads moving around a lot. And one could argue for putting log...

No problem.

To get the date of a file you could use xp_getfiledetails '@filename'.

But you'd need the full path for the file name.

Unfortunately you cannot exclude subdirectories (that I know of).

To only go to a depth of 1 you can set the second parameter to 1

exec master..xp_dirtree 'c:\',1,1

Hope that helps,

Hi Amol,

You can download the entire system table map from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en

Hope that helps,

Yep,

That's all there is too it. You don't need to backup the log but if you don't your log will grow and grow until it hits a limit.

Hi,

I you really need to do this using T-SQL:

create table #temp_table

(

filename varchar(1000),

depth int,

isFile bit

)

insert into #temp_table

exec master..xp_dirtree 'c:\',0,1

--this returns the entire file/folder structure for the c: drive.

select * from...