How do you tell what your machine name is and what is its IP
address?
Answer Posted / nithya
type in ur command prompt :
ipconfig
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is a crs resource?
how can you process messages in order asynchronously?
What is replication? : sql server DBA
What happens on checkpoint? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are statistics, under what circumstances they go out of date, how do you update them?
What authentication modes does sql server support? : sql server DBA
Can you redefine a table online?
What is a correlated sub-query? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
when does an alert gets signaled?