You can get the list of database users from sys.database_principals.

You can also use CHARINDEX();

IF OBJECT_ID(N'tempdb..#test', N'U') IS NOT NULL DROP TABLE #test;

CREATE TABLE #test(val VARCHAR(10));

INSERT INTO #test

(

...

In the Flat File Connection manager you can tell it to skip the first row ("Proprietary") by setting Header Rows to Skip to 1 and that the second row is...

APPLY was added in 2005 so that wouldn't work in 2000.

If SchedName is unique then I see no reason why a simple UNION wouldn't work. Like this:

SELECT

...

CirquedeSQLeil (4/13/2011)

---

Solo contract and it required him to...

I wouldn't do it unless there were major extenuating circumstances.

What's the wording of the contract? Is...

I'm sure y'all already know, but today is the last day of $299 price for SQLRally. Goes up to $349 tomorrow and then $399 May 1st. Also if...

GilaMonster (4/11/2011)

---

Jack Corbett (4/11/2011)

---

GilaMonster (4/11/2011)

---

Can't recall, I deleted...

GilaMonster (4/11/2011)

---

Can't recall, I deleted the PMs. Complaining...

Stefan Krzywicki (4/11/2011)

---

GilaMonster (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

I'm likely using the wrong word. the metrics that are gathered by SQL Server to improve performance on subsequent runnings of a query. I knew...

bitbucket-25253 (4/9/2011)

---

Requesting a favor from the denizens of the thread. A fellow member of my user group (ONSIG) is striving to present at meetings such as SQL SAT's and...

I definitely think there is enough material on SQL Agent to fill an hour. The only way to be sure is to write the presentation and then practice it....

I certainly won't turn any down.

CirquedeSQLeil (4/6/2011)

---

GSquared (4/6/2011)

---

Lynn Pettis (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

CirquedeSQLeil (4/6/2011)

---

Roy Ernest (4/6/2011)

---

Gail, Low blow aimed at Lynn... 🙂

I remember...

Grant Fritchey (4/5/2011)

---

Brandie Tarvin (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate term here> like myself...