both are correct

in the first query o\p

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2...

try sp_who4 active SP

backup database dbname to disk='path' with

stats=1

stats indicates percentage

can anybody tell me what is the time duration for 70-443 exam?

OK

i m fine with this

Thanx a lot to both of u

RBarryYoung (2/6/2010)

---

Well, I am no fan of loops, but since the goal IS to slow things down, this ought to do it:

CREATE PROC EXERCISE_TEMPDB_SILLY AS

SET STATISTICS TIME ON

SET STATISTICS IO...

7th step is not required in ur case

it is required while restoring master database backup.

can u specify the error u r getting?

but i haven't seen replication from sql 2000 to sql 2005

also there is no primary key on that table so its a difficult option

for configuring replication table must have primary key created on it.

do ur table have it(primary key)?

for more details abt WOW visit foll link

http://blogs.msdn.com/gauravseth/archive/2006/04/24/582091.aspx

attached file will help u for 1st question(details sql support for memory)

2. u cannot install 64 bit SQL version on 32 OS platform.

3. this is a component which helps 32...

see, there are different paths for certification.

http://www.setfocus.com/certify/mcitp.aspx

this link will tell u abt ur certification.

just decide where u want to go.

Ok

Let me tell u my scenario.

we hav 1 sql server 2000(srv1) on which database db1 is located which is OLTP DB,

in that there is table tb1 in which frequent inserts...

any opinions?

plz reply