By Looking at the error. you are using USE, GO , SELECT Keywords in batch file, which are SQL commands and cannot be run in dos prompt, the error is...

From SSMS, run this

SELECT * from sys.sysperfinfo where COUNTER_NAME LIKE '%TOTAL SERVER MEMORY%'

Alternately, use Performance Monitor and look for Memory Manager Object.

Check this link http://technet.microsoft.com/en-us/library/ms190924%28SQL.90%29.aspx

SELECT [Name] FROM MASTER..SYSDATABASES

Should give the list of all Databases in that Server (Instance)

To get it in all Servers, I am not aware of this, in SQL 2005. But...

GilaMonster (11/17/2009)

---

Neither of those limits processor usage by database. Table partitioning is just breaking a table into multiple chunks, possibly on different filegroups, resource governor controls resource usage based...

I have mentioned that location quoting my present server and...

TNSNAMES.ORA is a Network Configuration file in...

From the error description, it looks like the Database Files (Set of Database Files) are not matching and system cannot continue to attach the Database.

So check and make sure all...

What is the Package Protection Level?

Under what security context is the SQL Agent running.

I have been working on SSIS packages and believe me it is not a straightforward...

Starting from SQL 2005, SQL Server Profiler has the ability to trace what's currently running on the SSAS.

I recommend using the profiler to begin with.

GilaMonster (11/17/2009)

---

Processors can only be 'affinitised' per instance. What I would suggest is that you 'encourage' the developer to optimise his queries. Large table does not automatically mean high processor...

I am not sure if there exists a feature in SQL Server 2000.

Database partitioning is available in SQL 2005 / 2008, but it does not partition the processor workload.

Resource...

This may sound strange, I had a similar kind of issue couple of years back, (SQL 2005) when trying to modify / create Maintenance Plans from Management Studio on my...

I learnt a quick lesson... Do not reply to a post while talking over phone. 🙂

Yes Lynn you are right.

I forgot the Basic one.

You can start with a Weekly Full backup and daily Differential backup (if needed twice a day).

Monitor the Database growth over a few weeks period, and then decide to go...