if i have a SQL 2005 server ready and i have enough space for duplicate this database, i prefer use restore fullbackup and restore with transaction log + all the...

My service pack SP 4 hotfix and the build number is 8.00.2187

I remember when I update to SP4 (8.00.2039) i face this problem before.. kill the process but the spid...

i have server located in diffrent country and create linked server within the server.

I make sure

1. firewall is open for port 1433, 1434

2. user have permission to connect to...

what is your sql server service pack level?

I take 70-431 first then plan for 70-443 and 70-444.

70-431 is quite easy if you do sql 2000 before and it add some sql 2005 new feature (overview/ introduce)

Cheers

70-444 Optimizing and maintaining a database adminstration solution using SQL server 2005 release. receive today!

Should be 700? This is standard passing mark?

Is true for sql 2000 and sql2005 70-431

Btw, what you think about 70-444?

I just receive the book from amazon.

Read few page and find...

get my book at end of Aug from Amazon.

The book have exam voucher with 15% on exam and expired at 2010.

The book basically good but I think no enought information for some...

maybe my question bit out from your discussion.

but I keeping asking this question myself

in article, it mention for disk throughput capacity, we should monitor physical disk counter, disk read bytes/sec, disk...

i already order from amazon..

but the delivery and shipping date

Shipping estimate: July 9, 2006 - July 17, 2006

Delivery estimate: August 3, 2006 - August 22, 2006

one month- two month .. lol

I visit amazon today and why

Availability: This item has not yet been released. You may order it now and we will ship it to you when it arrives. Ships...

Kumar,

Any updated news? We also have this message quite frequent.

I found example given by dtamati very good.but that some bug when running the script with @Add_Row_Summary char='Y'

i also no sure why  declare @type tinyint=0,...

BlueIvy,

did you solve the problem already?

I have exactly some message with your.. sql hang and need to restart.

any solution? what you you...