you can find all system actions and user responses related to TSM

Click Client Messages reference.

http://publib.boulder.ibm.com/infocenter/tsminfo/v6/index.jsp?topic=%2Fcom.ibm.itsm.messages.doc%2Fmsgs5542.html

DECLARE @sqlver sql_variant

DECLARE @sqlver2 varchar(20)

DECLARE @sqlver3 int

SELECT @sqlver = SERVERPROPERTY('productversion')

SELECT @sqlver2 = CAST(@sqlver AS varchar(20))

select @sqlver3 = SUBSTRING(@sqlver2,1,1)

-- 1 = 2008 8 = 2000 and 9 = 2005 1...

Make sure the path exists for those files which are to be moved.

it should work.

Because this is only for one table..you can create trigger.

This should work well in your case.

Suppose Says you Have XGB of memory

I prefer 6GB for OS and the Remaining (X-6)GB for SQL by default on any server.

This will not work for Ram less than 10GB.

RPC Needs to be enabled in order to call a stored procedure which is on linked server database.

exec sp_serveroption @server='linked_server_name', @optname='rpc', @optvalue='false'

exec sp_serveroption @server='linked_server_name', @optname='rpc out',...

Thank you all..

GilaMonster (12/7/2012)

---

20% of the values for that column have changed since the...

GilaMonster (12/7/2012)

---

Why?

Have you tested and determined...

George M Parker (12/7/2012)

---

Be wary of running sp_UpdateStats if you are regularly rebuilding your indexes. Rebuilding an index causes the statistics to be updated with a FULL SCAN. If you...

Yeah there are...

Thanks for your reply.

Yes I mean user tables only.

I am talking about indexex(Starts With _WA_) these are automatically created right?

So I want to update them manually.

hope you get me know.

Thank you all..Vll try and let u know..

yes your'e right lowel,

Will go through the link you provided me.Let you know if i have doubts.

@SSCrazy

Hello

I just wanted to know like what all types of counters are to be checked during perfmon.

(OR)

and what values do we need to go though if we use DMV's...