What about the data in table tblStocks ?

(First, I strongly suggest you lose the habit of prefixing table names with "tbl" -- It does nothing to help understand the code).

Left...

Learning about stored procs.

I am greatly simplifying things here: you could consider stored procedure as containers where can you store SQL code in the database to let the database server...

So, the actual need was security and acces privileges.

OK, I was not aware as to where Adventure Works was headed in SS2K8 ...

Learning something every day...

I am now marrying an...

First off, WHY do you "need" (??) to create tables and set table ownership ?

Could you not just use a common table with an extra field like "OwnerID"to keep the...

No,

I did not try what you suggested.

What I did just try was to begin a transaction in a query analyzer window then do a select on a table.

I then started...

Ninja's_RGR'us (11/19/2008)

---

I forgot which thread had a similar problem but here'S something else to think about...

Even with a transaction if you run your code like this :

begin tran

if not...

@Gail

My mistake. I did not immediately realize that @data was a parameter.

Too stuck up in my personal convention of labelling parameters with prefix @ps_ (if a strting) to...

Gail,

I have always found your writings very interesting.

Regarding your solution, it is not immediately clear how your suggestion works in terms of being less susceptible to attack. Would you...

RML51:

Unless you will not allow the users to change their password to one of their own liking -- for instance banks DO allow users to change their PIN number and...

woops...

I did not try to run and test the code.

Thanks for doing this. Very useful.

Nice !

There also might be confusion between letter "G" and number 6...

what is your purpose exactly ?

if distinct sources are updating the same table at approximately the same time, SQL Server will process them one after the other.

You could have problems...

After sleeping over it, I am now considering creating a database that will only hold the table. That database can have a name known in advance and that will not...

Of course.

I would expect any "Senior DBA" to make a backup FIRST.

Now, this is a workaround I can live with. Good idea.

But I am still miffed at not having my points. (grin).