Viewing 15 posts - 10,141 through 10,155 (of 13,469 total)
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...
January 11, 2010 at 10:29 pm
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...
January 11, 2010 at 10:22 pm
there is a really good article here that i refer to all the time:
it shows how to set up your keys, and then a bunch of examples in TSQL to...
January 11, 2010 at 7:37 pm
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...
January 11, 2010 at 7:28 pm
davidsalazar01 (1/11/2010)
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...
January 11, 2010 at 6:26 pm
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...
January 11, 2010 at 3:22 pm
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...
January 11, 2010 at 12:21 pm
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?
January 11, 2010 at 11:52 am
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...
January 11, 2010 at 11:50 am
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...
January 11, 2010 at 11:29 am
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...
January 11, 2010 at 9:51 am
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,...
January 11, 2010 at 9:44 am
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...
January 10, 2010 at 11:44 am
naldo.samuel (1/10/2010)
January 10, 2010 at 7:28 am
Viewing 15 posts - 10,141 through 10,155 (of 13,469 total)