Is it the log file that grows to fill the disk? If so, clear out the entries one day at a time (or whatever interval best suits your disk...

The second one definitely won't work. It's not valid syntax. Try this - it doesn't work:

DECLARE @string varchar(100)

SET @string = '''A'',''B'''

SELECT * FROM sys.objects

WHERE name IN (@string)

I think...

Ah yes - in my great haste I assumed that your query resulted in the comma-separated list. I can't tell whether the issue here is generating the list, or...

SELECT @HCodes = DISTINCT...

That should do it, shouldn't it?

John

Please will you post the value of your variable (in other words, the command you're trying to run)? It may be that there's another way of doing it. ...

Those are horrible. I recommend avoiding that design if at all possible. I've seen it described as EAV (Entity Attribute Value), OTLT (One True Lookup Table) and MUCK...

Exactly what I was going to say. I would also have added that this will also grant SELECT on views in the schema, so be careful if that isn't...

Not sure whether Gail is being unduly modest or trying encourage you to do your own research. Either way, you may want to read this[/url].

John

No. Nor does the differential.

John

Restore your last good full backup and all transaction log backups after it.

John

Is that...

When you run it in Visual Studio, it runs as you. When it runs as a job, it runs as the SQL Server service account, or whatever proxy is...

Try it for yourself. Create a new login with the restricted permissions and log on as it. See what you can see and see what you can do....

Add a WHERE clause. And your STUFF function can be simplified. Since it's always the first character you're changing, and you always change it to M, the...

You need to use the STUFF function. Have a go at writing the UPDATE query, and post back if there's anything in particular that you don't understand.

John