Hi Joe,

How are you! if you haven't selected the person to help. I am willing to help also.

my contact info is db_dba2006@hotmail.com

Thanks

i still get same result

0.00            1920.96 19

159761.82     0.00      19

136151.20     0.00      23

0.00             2178.57  23

0.00             15.08       27  <--

116061.63      0.00        27

I want is like

159761.82    1920.96    19

136151.20     2178.57      23

116061.63      15.08        27

hi if i try doing is gruping at last quiery in union i get

is invalid in the select list because it is not contained in either an aggregate

data...

bellow is the code

ALTER TRIGGER [dbo].[updateOnErrors] ON [dbo].[bandwidth]

FOR UPDATE

AS

SET NOCOUNT ON

DECLARE @thisAdd VARCHAR(15),

@thisDIR VARCHAR(50),

@thisFN VARCHAR(50),

@thisQ VARCHAR(10),

@thisSer VARCHAR(10),

@thistest VARCHAR(50),

@thisNumber INT,

@firstIP INT,

@SecondIP INT,

@ThirdIP INT

SELECT @thisAdd = i.ipAddress, @thisNumber = i.errorNumber

FROM...

that way it does not work either. I need to get result in one line fro both view and procedure. Is it possible if i create cursor?

Thanks

I tried creating script on SQL 200 and then run on 2005 but it gives me error for

Password validation failed. The password does not meet Windows policy requirements...

but how can i schedule that so it can run automatically. Also Agent is dependent on that.

I have to restart it due to some billing batch and also web app too .

to schedule it from Windows scheduled task What do i have to do? I...

yes. It is valid with full rights to read and write.

thanks

Hi How can i check if "use Windows NT fibers" setting up  in my SQL server 2000 Ent. Edition?

i check the permission but everything looks fine to me and on top of that the copy and restore job works perfectly fine and all the changes also goes through so...

Can i change to SQL log on now? if so then how!!!?

Thanks

use reverse engineering on visio data diagram it will give you all the schema such as FK relation ship and details too.

I am missing that drive!! so how can i put new temp db file from another db server and also can i re direct it so can server get restarted!!

Thanks