Viewing 15 posts - 5,371 through 5,385 (of 7,429 total)
Form GRANT in SQL BOL
quote:
Members of the db_owner or db_securityadmin roles can grant any permissions on any statement or object in...
June 19, 2002 at 5:18 pm
Sorry no paramter to set the mime type in xp_sendmail.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 19, 2002 at 5:16 pm
Are you saying you want to setup the ROLE with REVOKE on all items, if so that is the default.
If for accounts and other roles then you will use
REVOKE ALL...
June 19, 2002 at 5:14 pm
Take a look here http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q270119
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 19, 2002 at 5:07 pm
Then you will need to add a third column for last change. Then either submit a GETDATE() value into it or create a trigger to update the value when a...
June 19, 2002 at 5:01 pm
If you query the load in the middle of the process the records may be available to query but if an error occurrs it will rollback the changes, if after...
June 19, 2002 at 4:57 pm
Actually if you concern is the encryption of sensitive data the point is to do a one way encryption this means the original data should be required to confirm it....
June 19, 2002 at 4:53 pm
Unfortunately this is a known issue and MS does not plan a change. There reasoning was that this was not intended to be done this way.
"Don't roll your eyes at...
June 19, 2002 at 4:43 pm
!= means not equal, NULL is not equal in comparison thus
Col != 'XYZ' will look for anything that does not equal 'XYZ'.
"Don't roll your eyes at me. I will...
June 19, 2002 at 4:33 pm
Don't know about the 1GB NIC unless your network will support and the backbone can run at that speed. I would aim for as much ram as you can possibly...
June 19, 2002 at 4:29 pm
My bad, thanks Meg for picking up the ball.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 19, 2002 at 4:14 pm
There is no need to do DBREINDEX on tempDb but I use it on all others (model can also be skipped). And yes I use DBCC UPDATEUSAGE after the reindex...
June 19, 2002 at 4:13 pm
DBCC DBREINDEX is the same thing as dropping and recreating the indexes except it does all on a single table at one time and you do not have to know...
June 19, 2002 at 4:09 pm
There is RAND but not a very good random number. You question is a little confusing to know what you want.
"Don't roll your eyes at me. I will tape them...
June 19, 2002 at 5:51 am
Actually should be
((Col <> 'XYZ' ) OR (Col IS NULL)) so it can
be either situation or
COL != 'XYZ'
does the same.
"Don't roll your eyes at me. I will...
June 19, 2002 at 5:40 am
Viewing 15 posts - 5,371 through 5,385 (of 7,429 total)