Showing posts with label SQL server. Show all posts
Showing posts with label SQL server. Show all posts

Monday, November 11, 2013

Limitations of SQL Server 2008 R2 Express

1. Maximum 10 GB per database.
2. Uses no more than 1 processor.
3. Uses no more than 1 GB of internal memory.
4. NO Maintenance plans
5. NO Database mail
6. NO User instances
7. SQL Server Agent
8. NO Full-text search

Wednesday, July 3, 2013

SQL Data Insert Via TSQL Server Cursor.


Monday, March 19, 2012

SQL SERVER Backup & restore database

  • backup database TestDB to disk = 'E:\testdb.bak' with stats = 10,password ='elshan'
  • http://www.mssqltips.com/sqlservertip/1849/backup-and-restore-sql-server-databases-programmatically-with-smo/