Sounds like a case of UAC getting in the way. Is it disabled on your machine?

your missing a GROUP BY clause

Are you using UNC paths or have you mapped a drive to the network share?

Cadavre (5/25/2012)

---

First, this is how you should post your sample data: -

SELECT WorkId, WorkName, CurrentStatus,

ActualStartDAte, ActualEndDate, ParentWorkId

INTO #yourTable

FROM (VALUES(100,'Define','Proposed','25-05-2007','26-06-2008',100),

...

You will need to pivot or cross tab.

There are two links in my signature to cross tabbing, also if you follow the second link in my signature on posting code,...

sys.dm_exec_sessions will give you that information, except numeric_roundabort, cursor_close_on_commit and implicit_transactions, just digging into where these would be.

It would call for the distinct or group by clauses to be added to your query in order to ensure that each row is unique in the result set.

You could...

If there...

So we can expect you to have tinnitus next week then Koen?

Jealous springs to mind right now.

I usually go to Download festival here in the UK every June, but not this year due to starting a family, so I'm gutted but...

Koen Verbeeck (5/25/2012)

---

Schadenfreude-Mei (5/25/2012)

---

Koen Verbeeck (5/24/2012)

---

As long as you keep all those grunge...

do you want a script which checks each databases to see if a particular login has been granted user access to the DB?

When a database is attached to SQL, the sqlserver.exe locks the files so that it has exclusive access to the files, the only way to backup databases via NetBackup without...

SQL 2000 is DTS not SSIS, are you sure its SQL 2000 or is it SQL2005/2008?

What coding issues are you facing?

Rebuild master just rebuilds the master database, but to be...

lookup the merge syntax in BOL or Google, its basically a fancy update/insert/delete combine statement, based on what you want, the main bits are the WHEN MATCHED and WHEN NOT...