Google says it can be found here:

http://adventureworksdw2008.codeplex.com/releases/view/86762

anthony.green (12/18/2012)

---

I was always told to not trust the sys view as it can differ from what was in the table, that was back in SQL 2000 days so unsure...

stating the obvious here, you should immediately remove that persons access to SQL server, and change the sa /other admin passwords.

make sure whatever application that is used to connect does...

another way to get your row counts; the indexes have the rowcounts built into the sys view:

--for 2005/2008:

Select OBJECT_NAME(object_id) as TableName,SUM(rows) as NumRows,index_id

From sys.partitions p

...

you can turn off the sp_execute scripting, so it's a cleaner CREATE / ALTER PROCEDURE.... by changing a flag the flag "Include IF NOT EXISTS Clause" in the scripting...

safzalhussain (12/18/2012)

---

we have a database of attandance system in which daily attendance recorded. there is a table in which one of IT guy directly modify his record for his late...

GilaMonster (12/18/2012)

---

I recommend restoring from the last good full backup. Since the DB is in simple recovery model, that amount of data loss (since the last full backup) must be...

wow Jack you replied to a ten year old thread!

it starts out pretty much like every other desktop install around the office that is connecting to Oracle.

Use the oracle universal installer to install the client tools. See your It...

well my colA and ColB resulsts seem to Me to be correct;

your expected results for ColB, where it's supposed to be by rank, doesn't match the data, i think.

ColC and...

mkarthikeyyan 89837 (12/17/2012)

---

Hi,

Please help to solve this !!!

i need to create tables and insert values in following tables, the scenario is

create table tbl1(tbl1_col1 int primary key ,tbl1_col2 int)

create table tbl2(tbl2_col1...

for the other direction, when you have the full SSMS and you connect to a lesser isntance, it varies based on what you connect to; i have 2012 developer installed,...

CELKO (12/11/2012)

---

In COBOL, the display and the internal format of data was the same. Each field had a PICTURE clause to define it. Your question makes sense only in that...

as suggested: changinbg old style join to new style ansi JOIN..ON:

SELECT

tblTransactions.PO_Number,

tblTransactions.PO_Date,

tblTransactions.Quantity,

tblTransactions.Software_Description,

tblTransactions.Unit_Price,

tblTransactions.SoftwareShortName,

tblTransactions.Transaction_Number,

tblTransactions.Transaction_Type,

tblBulkPurchases.Quantity_Remaining,

...

Stuart what is the relevance of this WHERE statement coming from?

WHERE ttask.id = 23

are you only capturing queries that match a certain task type?

it looks to me like that would...