Well, so far we have three. We definately need more people for this, here is your opportunity to work on something for the benefit of the MS SQL Server...

WayneS (4/20/2010)

---

Thanks Lynn. I remember that now after reading it.

Wonder why those parameters for ServerProperty...

My suggestion then, throw something together that mirrors the problem you are trying to solve and post that with sample data and expected results.

It would be better if you provided table DDL (CREATE TABLE statement(s)), sample data (series of INSERT INTO TABLE statements) for the table(s) involved, and expected results based on the...

SQL Server no longer tracks licensing information. You need to do that manually.

eseosaoregie (4/20/2010)

---

I am currently doing string manipulations with T-sql. In the where statement of my code I have the following substring function:

WHERE

SUBSTRING(LineRead,2,4) IN ('mon ','tue ','wed ','thu ','fri ','sat ','sun...

over-committed

Are you disabling the job via the GUI or code? If code, please show the code.

Steve Jones - Editor (4/20/2010)

---

I think the silence from PASS is a lack of resources. They are working on transitioning SQL Saturday, which is a higher priority than most other...

AndrewSQLDBA (4/20/2010)

---

Ooops, I forgot to add this little tid bit of info that would be helpful

One of the parameters will determine what query to fire off inside the sproc.

a little...

malachyrafferty (4/20/2010)

---

i get my fair share to as im generaly back and forward between the uk and eire, but i find once you show sundays are ok they aint half...

river1 (4/20/2010)

---

If you create a new database and then go to the properties of the database, then right click on the Files and then on the AutoGrow (of the log...

Thanks Wayne for jumping in here to help.

When you say the GUI isn't letting you do this, can you explain it in more depth? What is...

I say "It depends". What is being done? IF is a control-flow statement used in stored procedures and multi-line TVF's. The CASE statement is actually a function...