hi guys, I am getting confused as to the integration between NetBackup SQL Agent and SQL backups ie full, diff and tran.

My admin person is not very sure as to...

it is only with the Enterprise edition which cost 15k per processor if I am not mistaken?

However, if I am talking about system database maintenance - shall I also rebuild and reorganize indexes and update statistics?

Please note that I do not have a lot of the...

Hi all,

Thank you for help.

Feedback:

Exam - passed - pls do the suggested practices especially if they cover something you do not do daily

Issues with the practice code:

1) Issue with visual...

it just, looks clumsy:

set nocount on

go

begin try

begin transaction

declare @counter int

declare @sql nvarchar(150)

declare @t_name nvarchar(50)

set @counter = 0

while @counter < (select count(id) + 1 from

(

select row_number() over (order...

it'll work fine, and if I would like to execute sql based on the t_name?

declare @t_table nvarchar(100)

set @t_table= (select t_name from (subquery) as remove_table where id=@counter?

very nice, thank you

one more? - i want to reference the data further in the script,

ie instead of print, use sp_executesql where id=1

would I still need to create a...

Thank you, tommyh

Was just trying to get rid of tempory tables/table variables - is that possible?

thank you,

same stuff - it still says that the application is not registered.

I wonder if I need to do anything else rather than jsut install the files on my machine?

Microsoft Press:(

let me guess a variable? a table variable?

development edition 2005, 64 bit - 3 and and 1 mb