If you mean the SQL server log, it's just a text file. You can open it with notepad.

quote:

---

Why then isnt the default 8080?

---

Default values are picked for situations that work...

This was my first hard lesson learned in SQL. I've never forgotten it these past 8-9 years. I think every programming standards guide ought to mention this (as...

You're going to be in custom code territory with a function like this. You might try creating a calendar table with all business dates in it, then select...

For anyone who can stand the overhead of a temp table and dual selects, here's a template function that gives you row ID in your query. ...

The IDENTITY feature isn't intended to be continually reset in the fashion you describe. You need to create either a stored proc to maintain and reset your seed values....

quote:

---

Agree we need to change things a little.

Personally I'd like to see the moderate items (articles, FAQs, Case Studies, scripts) get much...

Just one off the wall observation: It looks like you may have a column that is not fully decomposed if your prefix and suffix are treated independently.

Maybe you need...

quote:

---

Here try this:

select @Temp as '@Temp',@T1 as '@T1', substring(cast(100+month(@t1)as char(3)),2,3) as 'month1' , substring(cast(datepart(mm,@t1)+100 as char(3)),2,3) as 'month2'

Gregory Larsen, DBA

If you looking...

quote:

---

thx for sharing. I paid for my MCSE NT4 for the exams. When Windows 2000 came out, I didn't have...

Why are you doing this in DTS?

If your tables are large ,you might be timing out just becuase it takes longer to do than the default script timeout value.

I would...

Basically, this is a missing feature of SQL server.

Lot's of ideas but they all boil down to this.

You would be surprised at all the functionality that can be shoe-horned into the IE browser. We've done what I used to think were miracles as web-based apps. ...

The death of COBOL

The death of the IBM MVS System Programmer

The Death of ....

We still have lots of COBOL/CICS system hanging around running on IBM MVS/MVT heirs maintained by $100K...