Like you said, you need to do the work with or without the award.

Gail made a very strong statement, which I agree with, that it's not something to work for,...

This is exactly why we would help you, because you are in need of some.

But it's...

yes I have.

What bothers me a bit is that you didn't provide any attempt data from your side.

This post sort of looks like you want us to do the thinking...

no need for a parameter......

just run:

EXEC sp_MSforeachdb 'USE [?] IF ''[?]'' NOT IN (''[master]'', ''[model]'', ''[msdb]'', ''[tempdb]'')

SELECT name as [?],

...

Look for anything where you will be a senior DBA's 2nd pair of hands, sort of like an internship; this way you will have a mentor, and learn more. The...

Try this:

select sys.dm_exec_sessions.session_id,sys.dm_exec_sessions.host_name,sys.dm_exec_sessions.program_name,

sys.dm_exec_sessions.client_interface_name,sys.dm_exec_sessions.login_name,

sys.dm_exec_sessions.nt_domain,sys.dm_exec_sessions.nt_user_name

,sys.dm_exec_connections.client_net_address,

sys.dm_exec_connections.local_net_address,sys.dm_exec_connections.connection_id,sys.dm_exec_connections.parent_connection_id,

sys.dm_exec_connections.most_recent_sql_handle,

(select text from master.sys.dm_exec_sql_text(sys.dm_exec_connections.most_recent_sql_handle )) as sqlscript,

(select db_name(dbid) from master.sys.dm_exec_sql_text(sys.dm_exec_connections.most_recent_sql_handle )) as databasename,

(select object_id(objectid) from master.sys.dm_exec_sql_text(sys.dm_exec_connections.most_recent_sql_handle )) as objectname

from sys.dm_exec_sessions inner join sys.dm_exec_connections

on sys.dm_exec_connections.session_id=sys.dm_exec_sessions.session_id

Linked servers are more used when you have queries running against them (instead of OPENROWSET function)

read up to get a better and more in depth answer:

http://sqlserverpedia.com/wiki/Central_Management_Server

http://www.databasejournal.com/features/mssql/article.php/3085211/Linked-Servers-on-MS-SQL-Part-1.htm

http://msdn.microsoft.com/en-us/library/ms143269%28SQL.90%29.aspx

This will steer you in the right direction....remember, Google and MSDN is your friend.

You are returning multiple rows for a single result value.

try with a top 1 in your select statement and see if it works.

The question was:

"Which of these SQL statements is correct? Please guess error message for those stements which are wrong. (select all that apply)"

So 1st you have to select all...

SSIS could be the answer for you.

Setup a "Global" job, with connections to each instance, with a Backup step.

You can host this job on a central server.

If space is an issue, you could look into shrinking, but keep Fragmentation in mind......

Leave it at 20gb, at least you know there is ample space to grow within the...

What are the initial sizes set of the mdf and ldf on this database?

It could be that the DB is allocated at 29gb as predefined sizes, but the actual space...

2010-05-08 14:10:34.720 spid4s Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected...

Execution plan.......