Hi Freinds, Have any of you encountered this error while performing the following execution? We are getting this ambiguous error in our environment....
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...
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 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, I just saw these commands in one forum... DBCC TRACEON(3604) DBCC DBINFO('master') DBCC TRACEOFF(3604) what is the significance of this trace...
hi..<br />when i am trying to implement the scenario in the article<br /><br /<a target="_blank"...
Hi..Sorry as i don't know to which topic this question belongs to. I want to know about UNC share point? krishna chaitanya.s project...
Hi .. northwind database in my server shows suspect.. I checked the error log for information.. error:823 severity:24 state:6 I/O error 23 (...
My friend came with this problem... His server is running sql server 6.5 and sql server 7.0. he install a named instance of sql server 2000,and...
hi i created a table named Finance yesterday in some database ( I forgot the name of the database)[V] how to find it? is there any command for...
hi when i try to open the database objects of a Databse from object browser in Query Analyzer ...it gives me an error as [microsoft][ODBC SQL...
hi what is meant by STATE in the error message? for example: Server: Msg 947, Level 16, State 2, Line 1 krishna chaitanya.s project...
hi everyone when u r detaching and attaching msdb database we have to add T3608 trace flag as start up parameter.. Besides this what r the trace...
How to start SQL server when Tempdb is corrupt? krishna chaitanya.s project engineer-SQLDBA
hi, why do we need to specify undo file during logshipping? krishna chaitanya.s project engineer-SQLDBA
hi every one are there any sites regarding to the case studies in the databse design? thnx in advance krishna chaitanya.s project engineer-SQLDBA...
Separate names with a comma.
