In which tcp/ip port does sql server run? Can it be changed?
No Answer is Posted For this Question
Be the First to Post Answer
What is sql or structured query language?
How do I completely remove sql server instance?
What is sql injection and why is it a problem? : sql server security
Explain foreign key in sql server?
Explain few examples of stored procedure over triggers?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to enforce security in sql server? : sql server security
internal language used in sql server 2000?
What is the ‘fillfactor’?
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
Explain important index characteristics?
What are the restrictions that views have to follow?