righto

I could pass timestamps in to denote when the employee started/ended.I don't need to know if an employee started>resigned >restarted.So that should do...

cheers Sam,

As an extension to this topic, how would you find out the “current” company or companies that the employee works for?

Would you  check to see if the start...

hi Joe,

you should probably look up "normalisation" and "foreign Keys" in the books online help  (BOL). 

Also, If I were you I wouldn’t worry about inner joins at the moment..Keep...

good,

I just wanted to make sure that there weren't any "hidden" dangers

je vous remercie,

yogi

Hi Grasshopper,

It wasn't the fact that I couldn't install EM on as many machines as I wanted.It was the fact that I didn't think that I should have to...

hiya,

I'll look into 'Microsoft SQL Web Data Administrator' sounds quite good.(we're dotnet people 🙂

I am curious though, as to the main reason for using osql.Is it so that "seasoned" users...

Cheers, Bill.

Looks like I'm livin in the past as far as sql datatypes are concerned 

Thanks,

           yogi 

ta folks, that did the trick.

you're dead right,

I never knew I could do that, cheers.

here's a wee clip from BOL

<clip>

 If a user-defined data type is created in the model database, it exists in...

ok Brian,

I can now connect using "Servername\Instancename", thanks

Now, when I try to create a new diagram, I get the useless  error:

<error>

an unexpected error happened during this operation

[MS Design tools- class...

morning,

I tried to connect using "\." but I got the error:

<error>

Unable to connect to server .\:

Server: Msg 17, level 16, state1

[ms][odbc sql server driver] [dbnetlib] sql server does not...

hi Brian,

thanks for staying with this 🙂

I'll have to try tomorrow.it's evening here in scotland.I'll keep googling tonight to see if  I can toubleshoot a bit more.Thereby buying me more...

sorry Brian, i wasn't making sense.

1) yes, sql server service runs.

2) yes, enterprise manager runs.

However, when I view the sql server group (in the "console Root" of enterprise manager), it...

hi Brian.

OK, now I’m really in trouble,

 I:

August 25, 2004 at 10:24 am