here is the logic

1.Begin a transaction

2. insert into category table

3. get max identity from this table

4. insert this max identity into article table

5. commit transaction

Create table test1(col1 int)

create table test2

(col1...

On the same example i posted in previus post i get similar results(same blocking transactions) from all three queries.

1. your initial query.

2. my query

3. your new query.

1. check if the table gg exists

2. check the owner name, you might need to write like this

owner.gg

this link will guide you log shipping setup via wizard.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1309728_mem1,00.html

Also go through BOL.

pankaj.srivastav (6/15/2009)

---

Hello,

Please help me to write a query of students exams result.

I want place a * with students got >=40 and =60 and =75 percent marks.

Example

Student Name ...

priya.preejaa (6/15/2009)

---

I have three tables.Am using asp.net,c# and sql server 2005 for my application.

So for a single insert button i wanna to store the data in three diff tables using...

venu_ksheerasagaram (6/15/2009)

---

But a little bit confusion- Is it necessary to give the Networkpath and Local path destinations eventhough my primary and secondary databases are on the same Server itself? or...

y_winny (6/15/2009)

---

I thought when you install a newer version of sql server and it overrides the older version on the PC. Can that be achieved when you already have sql...

One database can be attached to only one instance.

To give an...

venu_ksheerasagaram (6/15/2009)

---

Hi Everybody,

1)Here is a confusing problem with me.Let me know or provide me any links that give information about how to setup Transaction Log...

I did simulate the problem.

In window1 i wrote a query like this.

begin tran

insert into test1 values(1)

-- do not commit it

in window2, i login from a different userid and tried to...

Can someone pls look into this..

http://www.sqlservercentral.com/Forums/Topic734044-146-1.aspx

try changing date format under regional settings in control panel on the server to dd/mm/yyyy and see if it works. probably u might hv to restart the sql server.

Antero Ruiz (6/15/2009)

---

We can't run a full weekly backup because we don't have enough storage for the gigantic backup file, besides, when it was just 10TB we tried to run...

kindly put ur replies at http://www.sqlservercentral.com/Forums/Topic734728-169-1.aspx#bm734779