Hi Mohit

Nice posting!

One of my DBA brought your post in my attention when he was working on finding list of jobs current status is not successful.

I happened to notice...

Can you copy trace file to some where else? I have seen permission issue with trace file and gets resolved after replacing permission with inheritable permission manually. But this issue...

Rem70Rem (8/25/2010)

---

It is a standalone SQL server where I have only 1 instance of SQL 2005 (default not named).

I was told that the in-place install feature is pretty stable. ...

Are you using Clustering? Upgrade passive node(s), failover sql server to passive to make it active and then upgrade Active node which is now passive.

You are Welcome!!!

sundeep.maddi (8/17/2010)

---

Our company is planning to upgrade the present Cluster to an advanced hardware with SQL 2008 Cluster (A/P), as a DBA i have to confiure and install and mange...

pepe-274551 (8/18/2010)

---

when declaring a transaction scope we are using a IsolationLevel.ReadCommitted (C#) option for every transaction, some stored procedures have hard coded the NOLOCK hint that is equivalent to READUNCOMMITTED,...

Set "Repeat on New Page" to TRUE. You can do this by performing following steps:

Right Click on Group Header

...

My suggestion would be to capture profiler trace on SQL Server 2000 and replay trace on SQL Server 2008. You can analyze reports very easily using RML utility.

I have done...

e90fleet (8/18/2010)

---

Hi all,

We are trying to upgrade our transactional replication and the servers to SQL 2008 R2 and we are planning to do this in phases.

One of our publishing servers...

Retrieving data thru Linked server is relatively expensive. It is ok to use it if you are expecting small data set.

Lynchi Shea has put together nice article on this

You can try syntax in following pattern:

GRANT <permission> on <Object Name> to <User Name1>, <User Name2>..... <User Name n>

example:

grant select on test to SQLVillage,SQLVillage_Reader

P.S. Realized little later that Perry Whittle...

Please check SQL Server Browser service... I think it is not running and stopping you from connecting named instance.

you are right msdb db can not be altered. Instead of restoring this as different collation I would transfer contents like jobs, alerts/operators etc manually from old msdb db to...

Error indicating that it is an index. Try dropping it using DROP INDEX.....