Hiya,

Thanks for your prompt response.

Point taken about the data and clarity of my question.

My aim is to populate the countycode column of table my.ipaddresses by looking up the ipnumber from...

running sql 2008 enterprise and this script fails 🙁

it repeats the message >

Msg 208, Level 16, State 1, Line 1

Invalid object name 'tablename'.

for each one of my tables....

I believe you've...

the answer is I and II , not II and III.

does anyone audit these questions? i want my point (joke) 🙂

I've successfully used VB.NET CLR functions to replace TSQL Scalar functions.

2 instances where it works well are >

1) Conversion of String IP Address data to numeric form (and back)

2) Extraction...

The accounts listed in my first post are present on servers, i'm trying to reduce them to just those absolutely necessary.

Basically I want to simplify the security model.

r

did anyone ever solve this?

having the same issue here

rich

an excellent observation.

it's actually just highlighted a developer who has permissions she shouldn't 🙂

the sql authenticated user i am connecting with does have sysadmin priviledges, though doesnt have the coloured...

thank you for all of your input.

the reason for shrinking was to get it over to an old instance with inadequate disk space (development server).

The db size is actually much...

thank you both very much for your input

rgds

r

thank you for your speedy reply Gail 🙂

So if i change >

Select columns from tables where id = 3

into

usp_simpleselect @id=3

would there be multiple queryplans for usp_simpleselect @id=3 , usp_simpleselect @id=7,...

Bit of feedback for you, the script doesnt work if you have a 'uniqueidentifier' column >

Msg 206, Level 16, State 2, Line 1

Operand type clash: int is incompatible with uniqueidentifier

r

I like writing and do so in the form of blogs, music reviews etc on the web. I keep a technical blog as a braindump of stuff i've done as...

I've tried a trigger for the all encompassing 'DDL_DATABASE_EVENTS' but that didnt fire 🙁