Hans,

I'd suggest you go through these two articles by Gail. Excellent on how to create a server side trace, identify poor performing queries and then rectify/tune those queries.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

I've not faced WMI problem yet. may be you should reinstall it.

THIS url should help you.

Frankly speaking Jeff, I'm not even fraction of a percent of what you're...

Jeff, I work for HP GCI(Global center of India, Bangalore). I dont hv a personal website of...

rambilla4 (7/19/2009)

---

Prod_1.mdf, Prod_2.ndf in file group 1 and Prod_3.ndf in file group2 and prod_1.ldf, prod_2.ldf.

and my prod_2.ndf is got corrupted:

Can we restore ONLY prod_2.ndf file from the backup file...

rsteckly (7/18/2009)

---

I have worked primarily as a developer and don't really know much about the DBA/Database Developer world. I'd prefer to work for clients remotely. Is there a...

karthimca07 (7/18/2009)[hr

i have database named DBOIL

under this i hv stored procedures named Insert_IndentRaising

my new database name is DBOIL0910

when im tried as you suggested..,

insert select DBOIL.dbo.Insert_IndentRaising

it gives error..

how to use insert...

what is the relation between number...

To bring the database to online mode, run this.

alter database yourDBName set online

can you verify if the sql server service is running or not?

If you're able to ping the target server, open sql server surface area configuration, click on "Surface Area configuration for services and connections" and then click on remote connections. Select...

you can also have a flag field on the target table with a default value of 0 and update it to 1 from within your trigger statements.

this way u'll be...

you can copy your backup file with a different name(am not sure if same file will work) and then fire the restore command as suggested by Lowell in two different...

There are some experts who do data recovery from crashed hard disks or normal hard disks for recovering data files but as Jeff said, if you'd have shut down your...

Can you have a look at peer to peer replication...