Can I change memory to temp db anytime?

There is one server contains no maintance job and temp is 9MB and server has 3583 memory , change temp to 500MB? and there is another server that contains...

There is one server contains maintance job and temp is 9MB and 7MB is available. There is another server that contains no maintnance job and temp is 213.13MB and 209...

Terry, I get Demo: Full msdb log and temp log alerts. do you know how I can fix it?

I am new with company. I found out that there is no jobs done on the SQL server. They have backup through backup exec.

Thank you, I will try to that. Also in the servers that my company have in the sql server agent have no maintentace, I found out that NT administrator does...

I am new with DBA work, I was giving a server which contains no optimization,transaction logs, no integrity, no full back to be set up on schedule jobs. I was...

Thank you

Thank you, but still having problems. This what I wrote: Select * from CSWReportDatabase.CSWReportDatabase.dbo.package_lists

and this is what I get:Could not find server 'CSWReportDatabase' in sysservers. Execute sp_addlinkedserver to add the...

Select * from CSWreportdatabase.CSWReportDatabase.package_lists. This what I did and still get an error:Msg 208, Level 16, State 1, Line 1

Invalid object name 'CSWreportdatabase.CSWReportDatabase.package_lists'.

CSWreportdatabase = linked server,CSWReportDatabase=database in linked server,package_lists=table in...

Can you show me how?Thank you

How can I get data from linked server? I do this:SELECT *

FROM CSWReportDatabaseUPSMD.CSWReports.package_lists and it's not working.CSWReportDatabaseUPSMD=name of...

Thank you