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?

sorry i was confusing the express versions to evaluation versions; like you said, evaluation versions are timelimit handicapped, but have everything the developer/enterprise versions have.

express version doesn't have all that...

you'll have to purchase the 2008 Developer Edition in order to work with cubes/analysis server/BIDS/Integration Services;

those functions are not included in the free express versions. the express version comes with...

there is no difference; SQL is smart enough to know there is no reason to retrieve rows for the count() function, and does it the fastest way possible; count(*),count(someColumn) and...

what you want to do is create a few roles in your database first. once the roles are created, then you want to remove your user from the db_owner role,...

changing lock styles has a very minimal impact on queries, especially in SQL2005 and above.

For example, unless you have a LOT of updates going on every x milliseconds, SELECT...

would it be easier to create a role in the production database that has execute access to the 50 procedures, and then use a variation of Seth's script to add...

naldo.samuel (1/10/2010)

---

ei can you send me a file of SQL 2000 that is already installed my email add is samuel.naldo@yahoo.com,Because i cant run mine it always have error in the...