Hi Wes,

quote:

---

Well I figured it out. the time isn't zero filled to a 24 hour clock. Say the time was midnight and...

Hi Jody,

quote:

---

I think about this topic every day. We have a mixed bag of NT and Unix users across several domains, Sql...

Hi Bigman,

the result of the operation can be checked easily with this one

/*

Name: Listet sämtliche Datenbank-Optionen auf

*/

SELECT LEFT(name,30) AS DB,

SUBSTRING(CASE status & 1 WHEN 0...

quote:

---

you also get single digit numbers which isn't possible if it is doing the count from 1/1/1746 or whatever the year is....

Hi there,

today I've stumbled over an (undocumented?) xp. XP_DIRTREE and some sample code

CREATE TABLE #dir(datei_dir varchar(255), tiefe int, ist_datei int)  

 INSERT INTO #dir ...

Hi Wes,

you get a result similar to

Alternate Name (null)

Size 83886080

Creation Date 19970627

Creation Time 90233

Last Written Date 19980312

Last Written Time 204127

Last...

Hi Wes,

quote:

---

I am using xp_getfiledetails to pull back the time and date of last write when I look at the time it...

quote:

---

nope...no erros just invalid user sa

---

what do you mean by 'invalid user sa' ???

Cheers,

Frank

Hi els,

quote:

---

The database in question is composed of aerial photos, so it is not going to grow or change. The database size...

Hi Brian,

quote:

---

If you sign in through QA and try both, you'll see the difference even though BOL is not very clear. If...

Hi Martin,

quote:

---

I've been set the task of converting an app that uses DOS B-Tree style databases to SQL. One thing I'm...

Hi Michelle,

quote:

---

We will have to investigate this a bit to see what we have in Java that will work out & up...

quote:

---

One would expect a more reponsible approach to QOD from you Frank.

As an experienced DBA you must try to follow standard procedure...

Hi Graeme,

quote:

---

Would anyone be able to tell me why the following error would have occurred

..

Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213: [Microsoft][ODBC...

What about using direct SQL statements instead of stored procedures?

Or even better dynamic SQL?

Cheers,

Frank