MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
FAQ  
Administration  
Backup/Restore  
Connectivity  
Development  
General  
Installation  
OLAP  
Replication  
Transfer/move  
Trouble  
SQL 6.5  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
History  
Search  
Traffic  
Related Links  
     
Your button logo
Add to Favorites
 
     
 


SQL Server FAQ

SQL Server Administration FAQ

  • How do I administer SQL Server remotely?
  • How do I go about using/changing my settings to use the SANs protocol?
  • How do I mark the stored procedure to automatic execution?
  • How do I report information about current users and processes?
  • How do I report information about the active locks?
  • How can I add a user-defined error message?
  • How can I change the database owner?
  • How can I change the object owner?
  • How can I change the sort order and character set?
  • How can I compare the data in two tables with identical structure?
  • How can I compare two databases?
  • How can I get detailed information about locking?
  • How can I grant to user the RESTORE DATABASE permission?
  • How can I rebuild the SQL Server repository?
  • How can I restore the user databases after reinstall SQL 7.0/2000?
  • How can I show/hide system databases and system objects?
  • How can I start MSSQLServer service at 6:30am and stop it at 6:30pm automatically?
  • I am a dbowner. Can I restrict access to my database for the 'sa'?
  • I changed the name of NT server. How can I change the name of SQL Server?
  • I forgot the sa password. How I can reset it?

  •  

     
    Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

    (c) 1997, 2010 Bits on the Wire, Inc