Before you detatch the database and such I'd sugggest you try one other thing first.

Add yourself to the local machine Adminsitrators Group. By default this group should have admin...

In order to access the site settings you need to have certain rights. By default I think you need to have admin rights on the machine, although this could...

It's basically just what you described... Configure the Report server outside of the firewall, DMZ or something perhaps... Then you just need to make certain you configure your datasources...

I suppose it would depend on what exactly you are trying to do. The MSDN article you reference seems to be more aimed at moving the databases, not the...

So I've given this a bit more thought and did some testing. I'm not sure if it would save you any time, but another approach you could take to...

Well your DBA is somewhat correct. Will a trace affect performance of the database? Yes. If setup correctly as Bru mentioned above, it should have very minor...

If you take a trace of the system, you'll be able to see what time the view is accessed. then just look at the jobs scheduled to run at...

I know this thread is a bit old and hopefully you found an answer prior to this, but if you didn't one of he tools I've used int he past...

no apologies necessary Jeff. Like I said once I re-read my comment, I realized I didn't make the point as strongly as a should have. Thanks for the...

Yup,...

OK you've got a couple of things going on here...

1) it looks like you're using Ad-hoc dynamic SQL in your app to talk to SQL server. This is a...

Alvin Ramard (2/5/2010)

---

CirquedeSQLeil (2/5/2010)

---

Anybody notice that the Thread has surpassed 11,000 posts?

Yes, but you'll have to wait for Gail's Blog post on DBCC...

by address are we talking company address or personal?

Also, how does that fall in line with German/EU laws on privacy and such? Could be another factor on how it...

at the very least A) but it depends...

part of it would depend on if it was a question posted showing an absolute lack of knowledge on what that...

I'd suggest you run profiler and find out if you are doing what you think you are doing with your inserts, ie. doing them one at a time like I...