i mean

SELECT * FROM fn_virtualservernodes()

you can use this function once u connect through powershell.

select * from ::fn_getvirtualservernodes()

i believe it should be

RESTORE DATABASE <suspecteddatabasename> WITH RECOVERY

Is that possible to put this in a job and schedule it run on daily basis.

http://technet.microsoft.com/en-us/library/cc966545.aspx

http://blogs.msdn.com/sqlblog/archive/2006/09/25/whitepaper-working-with-tempdb-in-sql-2005.aspx

Hi Ps,

Is it sql server 2000 or 2005. In 2005 we have better ways of monitoring the tempdb usage.

Using the linked server concept, we also need to load the ole's in sql server to get the clients disk space data. using the power shell, its quite simple.

here is one link

http://www.simple-talk.com/sql/database-administration/why-this-sql-server-dba-is-learning-powershell/

No need to have 2008. We can install on one server and can remotely access the data from the client server.

I have already implemented such a design in my place. I believe much better to achieve the same is using the powershell, where you no need to create the linked...

Trigger will be fired only corrospoding parent object gets events.

Is awe enabled on the sql server? Also see the performance counts on the sql server memeory manager for total server memory and target server memory.

create a view out of this.

Here is one link.

http://www.sqlservercentral.com/articles/Miscellaneous/sqlserverstatisticalfunctions/1255/

You cannot connect to sql server 2005 from SQL Server Enterprise Manager. I need to install sql server management studio express for express edition.