Hi Satya, Please find the details that I have observed: --Step 1--Serivce Broker Status on the database: SELECT name ,database_id...
Thanks Satya!!! The service Broker is activcated on the database but all the queue monitors are showing as Inactive in the instance. I think we need...
Yes Satya... This is the first time we are seeing this error [:(]
Hi Freinds, Have any of you encountered this error while performing the following execution? We are getting this ambiguous error in our environment....
thnx a lot ....... posted 1 issue......got more stufff......... krishna chaitanya.s project engineer-SQLDBA "To be confident of what u r...
I am getting the following error when i try to login using Query Analyser. Please help me to resolve it. Server: Msg 11, Level 16, State 1...
hi all i have one strange question why we require log file for TEMPDB? krishna chaitanya.s project engineer-SQLDBA "To be confident of what u r...
hi got it...thnx a lot krishna chaitanya.s project engineer-SQLDBA "To be confident of what u r accepting",I would say,"U have got to understand...
why we r using <u><b>GO</b></u>when we specify queries.........?<br /><br />question seems to be silly....but pls[<img...
Hi... OPENXML is a rowset provider similar to a table or a view, providing a rowset over in-memory XML documents.....what is meant by in-line...
hi i have some doubt... Is it good to set query timeout and lock timeout values using sp_configure statemnt? krishna chaitanya.s project...
oh! my concept about truncate is wrong then..... Truncate is minimally logged.....not non-logged operation.. thnx a lot satya krishna...
Hi i have one database which has employee table it has empid,empname,bonus,salary columns.. most users are accessing the salary column and they r...
Hi....sorry this is a general question... In which scenarios are UDF's are useful rather than stored proc's? krishna chaitanya.s project...
hi, i heard that TRUNCATE is non-logged operation.Now i have one doubt regarding this.. Suppose during logshipping scheduled intervals if any one...
hi madhivanan....yes u r true.it's undocumented... let me give exact info abt this proc the above stored proc some parameters... sp_MSobjsearch...
Hi hemant and madhivanan.... i got one stored proc which is too good for to search any object in any database.. try this.... sp_MSobjsearch...
By default sql server 2000 operates at an isolation level of READ COMMITTED. To determine the transaction isolation level currently set, use the...
Hi satya.... it's nice to see the pages which r in buffer cache,proc cache.....vov gr8 thnx a lot for the extra info... krishna chaitanya.s...
Hi sekhar, BOL(Books On Line) is ur best friend !!!! krishna chaitanya.s project engineer-SQLDBA "To be confident of what u r accepting",I would...
Separate names with a comma.
