Oh lordy... I can see it now... some DBA decided that (s)he was gonna cleanup "unused" SPIDs and wrote some proc to kill all SPID's that don't have "Runnable" as...

Gosh... I don't know, but I'd like to know.

Anybody got any ideas on this one?

Why can't you just use BCP for this?

First, I think you posted this on the wrong forum.

Second, that type of error normally means that there's something wrong with either some slow code that needs to be reworked...

So.... what happens if a step is reopened more than twice? Does it still work? And, heh... you've just gotta know that will be the next request because...

Do you have any idea how rude you sound? "please send it immediately". Sounds more like an arrogant command than a friendly request. Learn some etiquette... IMMEDIATELY!...

If that SELECT is returning the values you want, then...

SELECT obj.name Table_Name, sycol.name Column_Name,Len(sycol.name) 'Data Length', t.name DataType, sycol.Length

INTO #yourtemptable

FROM sysobjects obj

INNER JOIN syscolumns sycol ON (obj.id=sycol.id and obj.type='U'...

Maybe I'm missing something, but, for the record... I've never heard of a loan being specifically for "the last day of the month". I've seen loan dates of, for...

First step of becoming a DBA is learning how to find stuff like this out... visit the Microsoft WebSite.

Not my idea, but... find's files for current database and makes a report of used, unused, and total size...

select [FileSizeMB] = convert(numeric(10,2),round(a.size/128.,2)),

[UsedSpaceMB] = convert(numeric(10,2),round(fileproperty( a.name,'SpaceUsed')/128.,2)) ,

[UnusedSpaceMB]...

thusi (11/23/2008)

---

Hi guys

Just letting you know that I did manage to write some sequential code to do this. Don't think you can simply do it in a single sql statement..so...

technicx101 (11/16/2008)

---

Hi,

I have a table with 33 columns of Skill types e.g. Skill1, Skill2, ..etc. A particular skill, say, "C#" can be found in any of the columns. Basically...

I'm pretty sure that there is... attach one of the files and a record layout and let's see what we can do...

It's simple... one of the two columns you join on is an INT... the other is not and contains a number larger than what an INT can handle.

So, how did things turn out?