Hi derrick

well I must be having a really bad day as i cannot see it

i canot open up the task that does the backup as that gete ther min-max error

i...

Hi Derrick

sorry i do not see that anywhere in the maint plan

can you be more specific. i am using sql server 2005

now i have another issue with this stupid min-max...

Thanks Steve

appreciate the info

Jim

Hi Steve

another issue i just saw

i was trying to edit the "Local server connection" and cannot

i had copied this maint plan over from s80 server to ss73 server

i added a...

Hi Steve

found it

I kept clicking the pull down arrow for Manage Connections instead of clicking the button

Thanks

Jim

Anybody ?

Excellent Derrick

I am back in business

Thanks

Jim

Hi Stsve

i do not see a Main Plan Editor in SSMS

where is it ?

Jim

Hi E. Hendrix

I am not sure just what this script does. Does it generate the sql to make the change or does it actually make the change ?

Do you have...

Thanks Waynes

i am new to sql server sql; coming from oracle

will have to look at these tables you mention

Jim

Hi Jason

unfortunately i work at an AFB and they block alot of sites & blogs so i cannot get to them

i will have to look at them from home

Jim

Thanks pankushmehta

sorry

had an extra comma after program_name:

select

a.dbid,

CAST (b.name as varchar(90)) as database_name,

CAST (a.loginame as varchar(36)) as loginame,

CAST (a.hostname as varchar(18)) as hostname,

cpu,

a.login_time,

CAST (a.status as varchar(18)) as status,

CAST (a.program_name as varchar(50)) as...

Thanks Shawn

i was able to use two tables to get what i wanted for now:

select

a.dbid,

CAST (b.name as varchar(90)) as database_name,

CAST (a.loginame as varchar(36)) as loginame,

CAST (a.hostname as varchar(18)) as hostname,

cpu,

a.login_time,

CAST...

Hi Shawn

i do not see the dbname in the table (sys.dm_exec_sessions) as i do in sp_who or sp_who2.

and i do not see where i can use sys.dm_exec_sessions to get the...