Thanks bud, maybe for once, I might have done somethin right 🙂

oh, for decent error messages.

thanks all, for taking the time.

yogi

Thanks for the advice folks,

The problem was that this had occurred at the site over a week ago, but I was only told today.

I will go back over the...

Great,

Looking forward to it.

Cheers,

yogi

thanks bud,

i'll have a look.

cheers,

yogiberr

Hi Andy,

Thanks for the reply.

That's a bit of a bummer.I've been prowling for an article that focuses on setting up logins with minimal permissions , a sort of best practices..

has...

Hi Steve,

Will do.

Thanks bud.

yogiberr

Thanks, between the 2 approaches I'll get it done.

cheers,

yogi

Hi Prakash,

I'll give the free download a try.

Many thanks for taking the time.

Cheers,

yogiberr

Hi Mark,

Magic,Thanks for that.

yogi

cheers Andy,

I was previously unaware about 'scope_identity'

thanks,

yogi

howdy,

I managed to get this to work, probably dodgy, but it seems OK

I added this to the top of the query:

IF EXISTS

(SELECT 1

FROM tblCLient c, tblStore s

WHERE s.clientId...

hi bud, spot on, cheers.

I have noticed that the query will return 100 individual numbers, even if I supply a "clientId" (that does not actually exist in the database)...

Howdy, sorry to keep bleeting on with this query, but I realised the other day the fact I have multiple clients will affect the query.ie, the actual "storeNumber" will not...

Hi Mark,

I have literally just found the answer.(midnight here in sunny Glasgow)I was trying to copy on to a cd ROM that didn't have enough space for the massive LDF...

Hi mark.

Thanks for the reply.

I'm not really sure what:

"suppressing file extensions for known types in Explorer"...is but, When I run a search for the log file, it is indeed...