Search results for query: *

How do i rebuild master and reattach User databases.

Hey, What would happen if the SA password is lost and no others users exist or don't have sys admin rights? how do i retreive the password? THe enterprise manager doesn't work as its configured with the old password. Thanx yogitha

Hi there , I am in a process of creating a report using MS Datareport. I have written an Sql query. i want the serial no along with each row the query returns. eg. select empno,name,sal from emp 1. E001 sam 100 2. E002 yogi 200 3. E003 soni 3000 etc. Thanx in advance yogitha

Hi I have a problem where i want to change the select statement where clause upon a condition declare @finyr int select @finyr = 2002 select acct_no from acct_mast where case when month(deposit_dt) > 3 then (year(deposit_dt) + 1) >= @finyr else year(deposit_dt) >= @finyr end...

hi there, In the application we have developed we have used stored procedures in order to insert, delete and modify. For tracking the errors like primary key violation, foreign key violation, I am using the @@error variable and checking whether its a zero or not? if it is not zero(unsuccessful)...

Hi, I would like to select the second highest paid employee record from the employee table how do i do that thanks in advance yogi