Computer Helps
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/
Older Posts
Home
Subscribe to:
Posts (Atom)