On which table the SSIS SQL Server logs are stored?
How to view the error log for any specific instance?
What are row constructors?
What is live lock, deadlock and what is Lock escalation?
How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error.
What severity level errors are managed in TRY-CATCH block?
when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.
What are the required/mandatory parameters that have to be passed with RAISEERROR statement?
hp asking for replication floppy to do reinstall 25254 server assistant
I have table name'temp' in that I wanted to add some partial data for a particular column name 'policyno' where data is existing in that column. Ex.Policyno like 'R-KT-SK- EA-134526' like 100 records. In that 100 records some policynos are just like 134527 I mean with out prefix like'R-KT-SK-EA-' now I wanted add this prefix as 'R-KT-SK- EA-134527' for some 50 records. How can I add partial data?
In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?
When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.
How will you Handle Error in SQL SERVER 2008?