There is another side to this.

If you are running a 32bit OS, you'll need to make use of the PAE switch in the Boot.INI as well, to allocate more than...

To start off with, Express is free.

Express 2008 R2 will support up to 10gb DB, anything earlier will only support 4gb.

There are memory limitations etc....

Read up on all the differences:

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

try:

http://support.microsoft.com/kb/246133

should sort you out...

tsk...I meant WITH NOLOCK...my bad.

talla.rishi (7/22/2010)

---

Hi All ,

Error message :-

Rule check Result

Rule " Cluster share disk available check " Failed .

The Cluster on this computer does not have a shared...

set nocount on

use at the start of your query/statement

gaurav-404321 (7/22/2010)

---

I want to generate the script for all tables in one go not for one by one table

Also i want to generate the insert script for table data rows...

Go with tin or...

Have a look at your indexes....this scenario sounds ideal for fragmentation....

Right click the object, select Script Database/Table/etc -> Create to (select your wanted option)

gaurav-404321 (7/22/2010)

---

I am using SQL SErver 2005 express edition. Is there any tool available for free which can generate the scripts for database objects- tables ,sps , functions including table...

Do not use WITH NOLOCK on rows and tables.

Since there are shared components, you'll have to be very careful what you delete.

SQL Server registry entries will still be present, and can be removed if you are absolutely sure.

Whoa! sorry for my bad advice there, and thank you to Gail for setting me straight.

I learned from it as well.

Full Backup included the Databases as well as the log.

You can backup the log if you need to be able to restore to a certain point in time.

Read up on...

No, you cant, you will confuse SQL and your LSN sequence.

The Maint1 log backups will fail if you do a second full backup in between.

Differential will also be based on...