well, here's...

Minnu (12/19/2012)

---

Hi Team,

Am having a trigger, which will update a column when insert / update occurs,

for new inserting or updating records trigger is working fine, but

am having a table, which...

Abrar Ahmad_ (12/18/2012)

---

[font="Verdana"]Lowell, your support was superb, but is there any solution to the following new issue :doze:

That in previous releases i can define shortcut keys for my own purpose...

neither of those two flags are going to have any significant performance gains:

minimally logged inserts:

http://www.google.com/search?q=sql+server+trace+flag+610&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&rlz=

grow the files at once:

http://www.google.com/search?q=sqlserver+trace+flag+1117&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&rlz=

I'm skipping over the possibility of undersized hardware, memory, or slow disks...

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...