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  
Search  
Related Links  
     
Your button logo
Add to Favorites
 
     
 

SQL Server FAQ

Administration

  • 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?
  • Backup/Restore

  • Can I backup a database to a network device?
  • Can I restore a SQL 7.0 database backup to a SQL 2000 server and vice versa?
  • Can I restore from backup with another sort order or character set?
  • How can I backup/restore a single table in SQL 7.0/2000?
  • How can I restore a SQL 6.5 database backup to a SQL 7.0/2000 server?
  • How do I restore the master database?
  • Is it possible to restore a particular transaction from a SQL Server backup?
  • We have no any backup, can we restore deleted data?
  • Connectivity

  • Can I connect to SQL Server over the internet?
  • Can I use the SQL Server 7.0 tools to connect to SQL Server 2000?
  • How can I connect to SQL Server through a firewall?
  • What sql net-lib should I use to enable encryption?
  • What sql net-lib should I use to improve the speed of my network connections?
  • Why dialup networking invoked when database is opened?
  • Development

  • Can I work with registry from within T-SQL?
  • How can I check from the SQL Server whether the file exists or not?
  • How can I copy text or image into or out of SQL Server?
  • How can I create extended stored procedures?
  • How can I decrypt a SQL Server stored procedure?
  • How can I delete duplicate rows?
  • How can I edit the system tables manually?
  • How can I enforce to use particular index?
  • How can I export a query result set into file?
  • How can I get only the specified number of rows from my query?
  • How can I make database to be read only?
  • How can I remove foreign keys through SQL Server 7.0/2000 Enterprise Manager?
  • How can I return from within a T-SQL the list of all available OLE DB providers?
  • How can I return from within a T-SQL the list of all character sets and code pages?
  • How can I return from within a T-SQL the list of server's DSNs?
  • How can I return from within a T-SQL the list of server's hard drives?
  • How can I return from within a T-SQL the list of Windows NT/2000 groups?
  • How can I select only date/time part of a datetime value?
  • How can I send a message to user from the SQL Server?
  • How can I set database to a single user mode?
  • How can I use a variable for the columns/tables in the select statements?
  • How do I add 'n' working days to the given date and get the result date?
  • How do I delete a particular value for a key in the registry via Transact-SQL?
  • How do I delete an entire key from the registry via Transact-SQL?
  • How do I execute an operating-system command via Transact-SQL?
  • How do I get the date the object was created?
  • How do I get working days between two dates?
  • How do I move tables from one filegroup to another?
  • How do I perform the same actions for all databases?
  • How do I perform the same actions for all tables in a database?
  • How do I read from the registry via Transact-SQL?
  • How do I return the first day of the month for the given date?
  • How do I reset the identity column?
  • How do I return the last day of the month for the given date?
  • How do I run a DTS package from the Query Analyzer or stored procedure?
  • How do I run a T-SQL script through SQL-DMO?
  • How do I run SQL script located on the disk file, using Transact-SQL?
  • How do I write to the registry via Transact-SQL?
  • How to install SQL scripts and import data to SQL Server from the command line?
  • Is it possible to work with COM objects from within T-SQL?
  • Why SELECT INTO statement does not work?
  • General

  • Are there arrays in SQL Server? Or what is the array analog?
  • Can I set tempdb database to be in RAM in SQL 7.0/2000?
  • Could you give me the comparison of MSDE with SQL Server?
  • Could you give me the comparison of SQL Server with Access?
  • Could you give me the comparison of SQL 7.0 with SQL 2000?
  • How can I add SQL Server licenses?
  • How can I get the column's description from my stored procedure?
  • How can I perform a nonlogged bulk copy?
  • How can I view the SQL Server transaction log?
  • How do I migrate an Access database to SQL 7.0?
  • How do I migrate an Oracle database to SQL 7.0?
  • How is SQL Server licensed?
  • How many SQL 7.0 editions exist and what is the difference between them?
  • How many SQL 2000 editions exist and what is the difference between them?
  • How to detect if the SQL Server is installed on the machine?
  • What are good SQL Server web resources?
  • What is the difference between char and varchar data types?
  • What is the difference between clustered and nonclustered indexes?
  • What is the difference between Oracle and SQL Server?
  • What is the difference between permanent and temporary tables?
  • What is the difference between PRIMARY KEY and UNIQUE constraints?
  • Where can I download free case tools?
  • Where can I download SQL Server 2000 Books Online?
  • Where can I find MSSQL test exams?
  • Where can I get the benchmark tests for SQL Server and other RDBMS?
  • Where can I get the evaluation copy of SQL Server?
  • Where can I see the price-list for SQL Server?
  • Installation/Upgrade

  • Can you give me the links to upgrade from SQL 7.0 to SQL 2000?
  • How can I check what SQL service pack am I running?
  • How do I install the SQL Server client?
  • How do I test an installation of SQL Server?
  • Should I apply the SQL service packs in order or can I just apply the latest one?
  • What is the current service pack for SQL Server 7.0?
  • What is the current service pack for SQL Server 2000?
  • Where can I download the SQL Server service packs?
  • Where can I find the list of bugs fixed by SQL 7.0 service packs?
  • Where can I find the list of bugs fixed by SQL 2000 service packs?
  • OLAP

  • Can I run OLAP Services 7.0 and Analysis Services 2000 on the same computer?
  • How can I connect to OLAP cubes from the client's computer?
  • What hardware and software requirements should I have for installing Analysis Services?
  • What SQL Server editions support Custom Rollups?
  • What SQL Server editions support Data Mining?
  • What SQL Server editions support Linked OLAP Cubes?
  • What SQL Server editions support user-defined OLAP partitions?
  • Replication

  • Can I replicate data to Access or Oracle subscribers?
  • Can I setup replication on a single computer?
  • How can I replicate objects permissions?
  • How can I start replication agents via Transact-SQL?
  • How can I validate replicated data for transaction or merge replication?
  • How do we handle duplicate primary keys for transaction/merge replication?
  • Some of my text/image values were not replicated. What is the problem?
  • What SQL Server editions support replication?
  • Where can I get tutorials about setting up snapshot/transaction/merge replication?
  • Where does snapshot replication store replicated data?
  • Transfer/move

  • How can I transfer SQL Server databases to a new location?
  • How can I transfer the particular database diagram from one SQL Server to another?
  • How can I transfer the particular DTS package from one SQL Server to another?
  • How do I transfer data from/to another heterogeneous sources to/from SQL Server?
  • Troubleshooting

  • How can I fix lost users after attaching database with sp_attach_db?
  • How can I resolve the error 259?
  • How can I resolve the error 605?
  • How can I resolve the error 1069?
  • How can I resolve the error 80004005?
  • How can I resolve the error 80040e21?
  • How can I resolve the error 8007000e?
  • How do I resolve deadlocks?
  • How to troubleshoot SQL Server installation problems?
  • I am getting an error 1205 - what can I do?
  • I can run DTS package myself, but cannot schedule it.
  • I get the full-text search timeout error. How can I fix this?
  • I got an error that RPC is not enabled. How can I enable RPC?
  • My database has been marked suspect. How can I fix this?
  • My DTS package is stored inside SQL Server. Now I cannot open it.
  • The upgrade MSDE to SQL Server fails with the error about 'old version'.
  • Why cannot I see the SQL performance counters in PerfMon?
  • Why cannot I truncate the transaction log?
  • Why DTS Import Wizard fails when importing table with a timestamp column?
  • SQL Server 6.5

  • Can we mirror data from one SQL 6.5 server to another?
  • Could you give me the comparison of SQL 6.5 with SQL 7.0?
  • I am getting an error 1105 - what can I do?
  • I am having problems installing the service pack 5a (cfgchar problem).
  • I have duplicate identity value error. What can I do?
  • I reinstall SQL 6.5. How can I restore the user databases?
  • Is SQL 6.5 year 2000 compliant?
  • How can I delete/edit columns in SQL 6.5?
  • How can I exceed the 16 tables restriction for one query?
  • How can I install SQL 6.5 on my home WinNT WorkStation?
  • How can I move SQL 6.5 databases to a new location?
  • How do I remove the tempdb database from the master device?
  • My database has been marked loading. How can I fix this?
  • What are the useful undocumented DBCC commands for SQL 6.5?
  • Why do my device have negative size?

  •  

     
    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