What is the user_access_desc from:

select * from sys.databases

Yes, limit is 524 PB.

The Developer edition has the same features as Datacenter.

http://technet.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/10/commands-batches-and-the-mysteries-of-text-a-month-of-activity-monitoring-part-10-of-30.aspx

Not only index rebuild...

"

Two other considerations for the [sql_text] column:

...

Certain system features, such as automatic statistics updates, may cause surprising results to be returned in the [sql_text] column. For example,...

And are you sure that this isn't a heap?

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

Uncheck "Attempt to repair minor problems"

No. To run

dbcc checkdb('master')

db can be online. Error log says, that you are trying to run one of: dbcc checkdb repair

Show script that you use.

Why you run repair and not only check "Repair statement not processed."? To repair the db must be in single mode, to check can be online.

You can also for free use an evaluation license, according to MICROSOFT EVALUATION SOFTWARE LICENSE TERMS:

•You may install and use any number of copies of the software on your devices....

May help, may not help, that depends on the error. Post the exact error message

Have you tried this notation?

CREATE LOGIN [domain\login] FROM WINDOWS;

Maybe a domain name or login are not regular identifiers.

Choose location where you have a write permission eg: "Documents"

So change the path to the right one or make this folder if not exists.

Now I don't know what is not clear in adding the setup.exe with proper parameters in script. What kind of script do you mean? What do you want to achieve?

anoop.mig29 (7/22/2013)

---

hi soory for stupid question but whats difference between sql server and sql server agent ???

arent both windows services .if yes then why can we allocate memory to...

All answers here: http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2830-bulk_logged-recovery-model/