I did add that code and it prints all the dbnames correctly but it doesnt execute the backup command after it does back for some databases...

It's not erroring out..it just...

DECLARE complex_cursor CURSOR FORWARD_ONLY FOR

SELECT name from master..sysdatabases where name not in('Tempdb')

order by name

Open complex_cursor;

FETCH next from complex_cursor into @dbname

WHILE @@fetch_status = 0

BEGIN

set @dbname = upper(@dbname)

set @backupname = @dbname...

Very Nice Article..Roy..

Thanks For sharing...

Luke...I dont see what you typed in the second reply...

Thanks...

We have lot of servers to change..as long as it works..i think i can figure out a script to do that..

Unless anybody has the script...

THanks

we added indexes that did it..

It was done in 5 mins.

Thanks,

Bru..

Yeah i did change just as you suggested but i am going to check on indexes and stats..

Thank For Your Suggestion

Thanks Steve!

Thanks For The Tip...

Steve,

Thanks For Your Reply!

We are primarily using this to remove unused id's on a Server .If a login has not been used for 90 days we want to...

Thanks Very Much For You Prompt replies.

Thanks Again...

Guys,

One quick question...

When running Server Side Tracing...if we restart sql server ..Do i need to just start the existing trace

or

Recreate the Trace

In other words..will the trace be stopped or...

Thanks...Very Much!

I got an idea from your previous post...Thanks for you help!

Hello,

Is there a way we can do that Programatically.

Ignore the file that is being used...

Thanks,

Hello All....

Thanks For Your Inputs...

But my question is how do i Know..which one is currently being used or written to because i want to ignore that and load the rest...

Ken,

Yes..I have registered Sql 2000 Databases in the mangement studio...and trying to see if i can some how get the view just like the task pad....

Thanks,