help if I show the code.

--code starts

DECLARE

@CurDay  int,

@CurWeek  int,

@CurMonth  int,

@CurYear  int,

@CurPreviousDay int,

@CurPreviousWeek int,

@CurPreviousMonth int,

@CurPreviousYear int

SET @CurDay = DATEPART(dd, GETDATE())

SET @CurWeek = DATEPART(wk, GETDATE())

SET @CurMonth = DATEPART(mm, GETDATE())

SET @CurYear...

THis is what I came up with. Granted it is more then my original request but I thought I would play allitttle.

Thanks for the suggestions

please expalint the (convert(char(8),getdate(),120) + '01' )

Thx

Once again the ID10T error stikes. She was apart of a group that was denied access to the server. I know I looked at these earlier, but I missed it....

Thanks Alex for your responce. No we are still (thats another internal issue) not on active directory. We have tried forcing all of the BDC to update but that did...

That has been done also along with cycling the server and having her logon a differnt PC and attept to connect. All ended withthe same result.

I thought of that too. No there are currently no groups that have been denied. The problems did not occure until after she changed her Windows password.

10 are.

sqlbill,

Thanks. I just read that on their web site.  

Thank you for your help. I told them that it was more then likly not possiable.

I have also runn into problems with the server backup tool trying to back up the log and datafiles while the database is active.

I have noticed that in the last few years companies have been handing out titles instead of cash at evaluation time. They will say things like "We are promoting you...

Thank you for all of your responses. You are correct. I am running XP. And changing the reg. does not work. I am working with our friends at Microsoft to...

No my account did not change. I am an Admin on my PC. I can go into Rededt32 and see the servers listed in the keys in several locations....

In this new age of technology you might be able to expand your list of canadates if you allowed for remote administration. For example. I live in Ohio but I...