Interested to Buy Any Domain ? << Click Here >> for more details...
in my server i have 3 instances,one of them got failed, and
this cause we r not able to connect to server, how to know
which instance was dameged?
- 1 Answers
- 4560 Views
- IBM, I also Faced
- E-Mail Answers
Answer / sarojini makineni
Open SQL Server error log using notepad to know the Process
ID of respective instance of SQLservr.exe and stop such
process alone using Task Manager - (you may better download
procexp.exe to know the pid)
| Is This Answer Correct ? | 4 Yes | 0 No |
Explain the first normal form(1nf)?
What are the different types of lock modes in sql server 2000?
What are the filtered indexes?
Write a SQL query to delete a table?
Explain aggregate functions?
What is raid, and how it can influence database performance?
What information is maintained within the msdb database?
Explain what is the purpose of sql profiler in sql server?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is de-normalization in sql database administration? Give examples?
How to connect sql server management studio express to sql server 2005 express?
CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
