Thanks for the reply 🙂

I'd like to monitor my stored procedures on another server. I think I should use SP_Counts or TSQL_SPs templates but what if I need a combined...

anjan.ashok (7/1/2008)

---

you can copy entire database contents by using export wizard.

Choose destination db to which data is copied and run the wizard.

U can also save package as SSIS and...

preetha.sathyamoorthy (6/8/2008)

---

Have you created any function, stored procedure, trigger or Constraint for that table. If you have created any of the above for primary key, then also it will give...

There's no foreign key defined:ermm:

thanks for your replies anyway 🙂

TRACEY (5/5/2008)

---

Thanks re the ndf files...

For training - yes i would recommend new horizons i did that course for SQL 2005.

Forums are good too - people always willing...

jim.powers (5/5/2008)

---

My knowledge started...

TheSQLGuru (5/3/2008)

---

Peace - have your company hire a mentor for you for a short period of time. He/she can not only help improve performance in the short term but...

TRACEY (5/3/2008)

---

Interesting...Tell the department you are a DBA and needs administration rights on the servers....I had same issue they kept taking it away...I told them i have to read every...

Thank you 🙂

Does it have the same meaning in SQL2005?

Does runnig Profiler and DTA affect performance? Besides, what's the best duration time to run profiler for creating a trace file (e.g. 15mins, 1hr, etc.)

On the part of the application,...

auto close is turned off :rolleyes:

Thank you SSChasing Mays and SSC Veteran for the links 🙂 I'll go through them and let you know the result

Chandrachurh Ghosh (4/28/2008)

---

can you enquire about the hardware config. from the relevant department?

Also, what are the access rights assigned to you?....and are you the DBA?

It is very important before starting...

I've just started to do as your comments step by step though I have to wait for another department to install SP2.

I'll surely update you of the result.

By the...

Thanks a million Jeff 🙂