If the job is not scheduled, then either of the following has happened.

1) Someone removed the schedule in the maintenance plan

a) Open the...

I would recommend reviewing the view that...

Yes, 30GB is too much for SQL Server. I would recommend setting this to no more than 28GB and make sure the minimum is set to at least 1GB...

masood24 (8/17/2008)

---

hello dear 1st thank you very much for help but I have tried the query but it is not working message is successful with 1 row changed but actually...

No, it is not necessary to get everyone out of the db. But, you need to make sure you have transaction log backups scheduled. How often you schedule...

Use Add/Remove to remove a single instance. Instead of selecting to remove, select to change and you will be given the option to uninstall components.

Oops - forgot the temp table, thanks Jeff.

Yes, this can be done using an alias. Example:

SELECT t1.col1 AS t1_col1

,t1.col2 AS t1_col2

...

And, just to make things interesting - in SQL Server 2008 they changed it to: ssms.exe

You can check the aliases by using SQL Server Configuration Manager (which, I don't think you can use because of the WMI error you are getting).

You can also find out...

Did you update statistics with full scan?

This is very clearly spelled out in Books Online (BOL) under the topic default schemas. You cannot set a default schema for a windows group.

From Books Online:

If DEFAULT_SCHEMA is...

Verify that the client tools have been upgraded to at least the same version as the server you are connecting to. My guess is that your client tools have...

Let's try something else - verify the name of your instance for this server. Open the services applet, scroll down to the SQL Server instances, expand them so you...

The only time I see the icon without a green arrow is when I am connected to a cluster or there is some issue with connecting to that server. ...