kotlas7 (2/7/2009)

---

Hi,

We have a separate Reporting server(serverA)and we have another server(serverB) in which we are going to store report server database and report servertempdb.In this case do we need to...

peace2007 (2/7/2009)

---

I need to tune indexes on my sql2005 server but when I run a profiler trace using tuning template to get information about indexes, CPU becomes 50% to 70%...

Add user network services to the temporary aspnet folder and give full control....hope it helps

read this

http://www.sqlservercentral.com/scripts/index/64728/ [/URL]

to get index usage stats....

bart (2/6/2009)

---

I tried the registry change as shown at

http://support.microsoft.com/kb/896861

under the title "You receive error 401.1 when you browse a Web site that uses Integrated Authentication and is hosted...

Yes I get this message when i run it as query but not as job. since the job got failed i re ran it as query. but where am i...

This is probably a permission issue at IIS level....have a look at http://support.microsoft.com/kb/318380

pls post the trace flag results

Mike Levan (2/6/2009)

---

I am runnning this procedure on the same database, it is still running and now how cud i find out which indexes are rebuild and which are yet...

erin.meglich (2/4/2009)

---

Can someone please explain to me how exactly the permissions work within SQL Server?

I'm asking because I had a user who had a separate account which gave her ownership...

u can also use

Alter database [database name] set single_user

Alter database [database name] set multi_user

kerusy (2/5/2009)

---

How do i go about sending the backup to a network? This is because i would like to create the transfer as a task that is done from time...

It's not really recommended to Shrink your database weekly as this causes a lot of fragmentation and usually increases to the same size again, I would avoid doing this.....

I think am unable to explain the scenario.....

There's one single web application for each client....however each client will hav separate database...

If ther's a blocking/deadlock with one of the database....which causes...

my apologies..its a cross join..I reproduced it....tho...