Use profiler to trace the acivities and then from there you can get those list manipulating.

Yes if you have 2000 MCDBA then you can go for 70-431 for MCTS and 70-447 for MCITP direct upgrade.

You can use the maintenance plan that gives yuo lot of option and also helps to back up databases.

But why do u do these kind of job in production hours plan these activities in non-production hous or time when there is less activity in sql server.

Rahul,

goto profiler then move to events tab,

Select stored procedure - spcompleted, stmtcompleted.

select tsql - stmtcompleted.

move to filters and give the name of the database that you want to monitor

you...

You need to include the /3GB switch so that sql server can utilise more than 2GB of RAM else it will use only the default 1.7GB that it can use.

The easiest wat is to create a database using the enterprise manager available with 9i and then import/export the data. If you want to learn more about ORACLE  then go...

Try these links anyone might help you.

http://support.microsoft.com/kb/905616

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=575666&SiteID=1

For .net and SQL Server go for MCAD and take sql as elective paper.

Since you have posted in 2000 forum you have options of profiler/sysprocesses/perfmon with sql server stats else if your server is 2005 you have DMVs that will give more details...

Yes you have to use profiler to do this. You can start profiler from the programs menu move to SQL Server and start from there. You have plenty many options...

By default remote connections are not enabled in SQL 2005. You need to enable them in Surface Area Configuration Manager to allow tcp and named pipes connections. After doin this...

Its CHAR(9) to introduce a tab.

select ServerName, Alert, AlertDate from dbo.TNG_Alerts

where  convert(varchar(10),AlertDate,101) >  (select Convert(varchar(10),getdate()-@day,101))

order by ServerName

hope this should bring you the data expected.

Did you verify the diff backup file before restoration post the error please.