all my snippets I'm looking at do not have a space after any of the flags, for exampe -S TECH-01

should be -STECH-01

SET @sql = 'bcp "' + @sql +...

those all look like objects owned by INFORMATION_SCHEMA

since your cursor is hardcoded to sys.objectname, it is trying to revoke sys.COLUMNS , which does not exist, instead of INFORMATION_SCHEMA.COLUMNS , which...

the list of tables is usually child tables that reference the original table via a foreign key;

if the table is going to be dropped and rebuilt completely, rather than a...

falcon59x (1/12/2010)

---

Hey guys,

Thanks for the response they are really helping. When I incorporated searching for the schema instead of just using sys. I was actually able to knock 26 down...

i found out that in SQL 2005 and above, some of the data management views have the client ip address, and you can narrow it down to the specific SPIDs:

this...

another idea is to add a column of type rowversion and use that as a semaphore for whether the person should update;

so for example:

data example:

create table myTest(testid int identity(1,1)...

It depends on your approach. you can move the code that was being executed in the stored procedure directly into the trigger; that way you can insert from the INSERTED...

thank you so much for the sample data! makes it so easy to help!

you can do it by joining the table to itself, with a WHERE statement that is a.identity=b.identity...

yeah i had read an article about how to update 2005+ system catalogs as well; after all, service packs need the ability to do it, so it has to...

there is a really good article here that i refer to all the time:

http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm

it shows how to set up your keys, and then a bunch of examples in TSQL to...

yes Anam, you can...the last post i made with a code example did exactly that...the code was assuming there is a column named recordid, and it was the PK identity...

davidsalazar01 (1/11/2010)

---

Hello All,

I'm trying to retrieve only records that are ONLY 8 digits long and the datatype of the column is an int. Then once I retrieve those records...

ok i think i'm following along; i created a brand new database in SQL 2005, and ran the following script to generate the revoke statements; i think the difference for...

lets look at the details....show us the SQL you are using to identify objects you want to take away access from; that will really let us help you better.

if it...

since 2005, it's no longer possible. the old SQL 2000 syntax is ignored.

what is it you think you want to change, that cannot be done with the normal commands?